Please visit our sponsors !
The EndOfRecordset Event
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 og 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 |
Jump to: Top of Page
or HOME or
Printer friendly page
Search W3Schools:
What Others Say About Us
Does the world know about us? Check out these places:
Dogpile
Alta Vista
MSN
Google
Excite
Lycos
Yahoo
Ask Jeeves
We Help You For Free. You Can Help Us!
W3Schools is for training only. We do not warrant its correctness or its fitness for use.
The risk of using it remains entirely with the user. While using this site, you agree to have read and accepted our
terms of use and
privacy policy.
Copyright 1999-2002 by Refsnes Data. All Rights Reserved
|