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