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
Need an easy way to get data into XML, or transform XML to another format?
MapForce lets you map XML data to/from any combination of XML, database, flat file, Excel 2007, XBRL, or Web services data.
Then it transforms data instantly or auto-generates royalty-free data integration code for recurrent conversions.
Download a free, fully functional 30-day trial to experience the following features:
- Easy-to-use, graphical data mapping interface
- Instant data transformation
- XSLT 1.0/2.0 and XQuery code generation
- Java, C#, and C++ code generation
- Advanced data processing functions
- Support for all major relational databases including SQL Server, IBM DB2, Oracle, and more
- Visual Studio & Eclipse integration
Download a fully-functional trial today!
|
|
|
|
