ADO EndOfRecordset Event
❮ Complete Recordset Object Reference
An event is a subroutine that can be called automatically after a specific operation has occurred.
The EndOfRecordset event is triggered when you try to move to a record after the last record in a Recordset. This event can occur if the record pointer is at the end of the Recordset and the MoveNext method is called.
Tip: You can use this event to retrieve more records from a database and append them to the end of the Recordset, and then repeat the MoveNext call.
Note: Before this method returns, set the status parameter to adStatusUnwantedEvent to prevent subsequent notifications.
Syntax
EndOfRecordset(moredata,status,objrs)
Parameter | Description |
---|---|
moredata | A boolean value that if true it allows to append more data to the end of the Recordset |
status | An EventStatusEnum value that indicates the status of the execution of the event |
objrs | The name of the Recordset Object that triggered this event |
EventStatusEnum Values
Constant | Value | Description |
---|---|---|
adStatusOK | 1 | The operation that caused the event was successful |
adStatusErrorsOccurred | 2 | The operation that caused the event failed |
adStatusCantDeny | 3 | The operation that caused the event cannot be cancelled |
adStatusCancel | 4 | The operation that caused the event is cancelled |
adStatusUnwantedEvent | 5 | Prevents subsequent notifications before the event method has finished executing |
❮ Complete Recordset Object Reference