From RAD Studio API Documentation
Jump to: navigation, search


property OnEndOfRecordset: TEndOfRecordsetEvent read FOnEndOfRecordset write FOnEndOfRecordset;


__property TEndOfRecordsetEvent OnEndOfRecordset = {read=FOnEndOfRecordset, write=FOnEndOfRecordset};


Type Visibility Source Unit Parent
event published
Data.Win.ADODB TCustomADODataSet


Occurs when moving a recordset's row pointer past the last row.

Write an OnEndOfRecordset event handler to take specific action after an attempt to move to a row past the end of the recordset. No row navigation methods should trigger this event due to the effects of the Eof property. This event should only be triggered by internal recordset navigation operations or by direct access to the Recordset object (through the dataset component's Recordset property).

DataSet is the ADO dataset component that triggered the OnEndOfRecordset event. This dataset component also contains the recordset in question.

MoreData is a boolean value indicating whether there are more unfetched rows beyond the last row fetched prior to the OnEndOfRecordset event.

The EventStatus value (ADO EventStatusEnum) indicates the success or failure of the execution of the operation that triggered the event.

Note:  : A Recordset object's row pointer is distinct from the record pointer of its ADO dataset component. It is possible that the ADO Recordset object will generate row movement events without the ADO dataset component generating a BeforeScroll or AfterScroll event. A couple reasons for this are background updating and resynchronizing of the records as data is changed. The OnEndOfRecordset event is purely a Recordset object event and independent of any dataset component record navigation events.