Name

Recordset.EndOfRecordset Event — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

EndOfRecordset(fMoreData As Boolean, _
               adStatus As ADODB.EventStatusEnum, _
               ByVal pRecordset As ADODB.Recordset)

The EndOfRecordset event is called when an attempt to move the record pointer past the end of the recordset has occurred.

Arguments

fMoreData

A VARIANT_BOOL value that can be set to True if more data was added by the application to invalidate the current event. In other words, when this event is fired, it is an indication that the record pointer has gone outside the recordset. At this time, you can append more records to the recordset and set this fMoreData parameter to True, so that the operation can be attempted again.

adStatus

An EventStatusEnum value indicating the status of the current operation. The adStatus parameter is set to adStatusOK if the operation causing this event was successful. If the adStatus parameter is set to adStatusCantDeny, the event cannot request that the operation be canceled. If the adStatus parameter is set to adStatusUnwantedEvent, this event will not be called again.

pRecordset

The Recordset object that fired this event.

See Also

EventStatusEnum Enumeration, Recordset.MoveNext Method

Get ADO: ActiveX Data Objects now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.