Name
Connection.ExecuteComplete Event — (Versions 2.0, 2.1, 2.5, 2.6)
Synopsis
Private Sub con_ExecuteComplete(ByValRecordsAffected
As Long, _ ByValpError
As ADODB.Error, _adStatus
As ADODB.EventStatusEnum, _ ByValpCommand
As ADODB.Command, _ ByValpRecordset
As ADODB.Recordset, _ ByValpConnection
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 toadStatusErrorsOccurred
.
-
adStatus
(EventStatusEnum) Indicates the status of the current operation. If the
adStatus
parameter is set toadStatusOK
, the operation was successful. If theadStatus
parameter is set toadStatusErrorsOccurred
, the operation failed, and thepError
object contains the details regarding the error. If theadStatus
parameter is set toadStatusUnwantedEvent
, 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
Get ADO: ActiveX Data Objects now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.