ADO: ActiveX Data Objects

Name

Connection.ExecuteComplete Event — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

Private Sub con_ExecuteComplete(ByVal RecordsAffected As Long, _
                                ByVal pError As ADODB.Error, _
                                adStatus As ADODB.EventStatusEnum, _
                                ByVal pCommand As ADODB.Command, _
                                ByVal pRecordset As ADODB.Recordset, _
                                ByVal pConnection As ADODB.Connection)

The ExecuteComplete event is called when the execution of a command has completed.

Arguments

RecordsAffected (Long)

Indicates how many records are affected by the executed command.

pError (Error)

Contains details about an error that occurred if the adStatus parameter is set to adStatusErrorsOccurred.

adStatus (EventStatusEnum)

Indicates the status of the current operation. If the adStatus parameter is set to adStatusOK, the operation was successful. If the adStatus parameter is set to adStatusErrorsOccurred, the operation failed, and the pError object contains the details regarding the error. If the adStatus parameter is set to adStatusUnwantedEvent, this event will not be called again.

pCommand

Represents the Command object that was executed (if there was one).

pRecordset

Represents the Recordset object that results from the commands execution. This Recordset object can be empty.

pConnection

Represents the Connection object that fired this event.

See Also

Connection.Execute Method, Command.Execute Method, Recordset.NextRecordset Method, Recordset.Open Method, EventStatusEnum Enumeration