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
 |
W3Schools' Online Certification Program
The perfect solution for professionals who need to balance work, family, and career building.
More than 4000 certificates already issued!
|
The HTML Certificate documents your knowledge of HTML, XHTML, and CSS.
The JavaScript Certificate documents your knowledge of JavaScript and HTML DOM.
The XML Certificate documents your knowledge of XML, XML DOM and XSLT.
The ASP Certificate documents your knowledge of ASP, SQL, and ADO.
The PHP Certificate documents your knowledge of PHP and SQL (MySQL).
| 
