Write an OnExecuteComplete event handler to take specific action after the ADO connection object has successfully executed a command. The OnExecuteComplete event fires after the corresponding operation (executing an ADO command) has completed execution at the ADO Connection object. Calling the Execute method will lead to this event occurring. 

Connection indicates the TADOConnection component executing the ADO command. 

RecordsAffected indicated the number of rows in the table that were affected by the execution of the command. For instance, if the command deletes rows in a table, RowsAfftected indicates how many rows were deleted (possibly less than all rows if a WHERE clause is used in the command). 

Error is an ADO Error object. See the Microsoft Data Access SDK for more information on using ADO Error objects. The Error parameter is only set if an error occurred during execution of the operation that triggered the event. In this case, the EventStatus parameter will contain the indicating value esErrorsOccured. 

The EventStatus value (ADO EventStatusEnum) indicates the success or failure of the execution of the operation that triggered the event. 

Command is the ADO Command object executing the command. If no Command object was used, this parameter contains a nil (Delphi) or NULL (C++) value. 

Recordset is an ADO Recordset object containing the result set for the command. Recordset only contains an ADO Recordset object if the command was a SELECT statement, otherwise it contains a nil (Delphi) or NULL (C++) value. 

Execute 

ADO Connection Events