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
 |
|
Get Your Diploma!
W3Schools' Online Certification Program is the perfect solution for busy
professionals who need to balance work, family, and career building.
The HTML Certificate is for developers who want to document their knowledge of HTML, XHTML, and CSS.
The ASP Certificate is for developers who want to document their knowledge of ASP, SQL, and ADO.
|
|