atFirst( )

Topic group Related topics Example

Returns true if the row cursor is at the first row in the rowset.

Syntax

<oRef>.atFirst( )

<oRef>

The rowset whose position you want to check.

Property of

Rowset

Description

Use atFirst( ) to determine if the row cursor is at the first row in the rowset. When atFirst( ) returns true, the row cursor is at the first row. In most cases, atFirst( ) is an inexpensive operation. The current row is usually compared with a bookmark of the first row made when the query is first opened. However, atFirst( ) may be time-consuming for certain data drivers.

A common use of atFirst( ) is to conditionally disable backward navigation controls. If you know you are on the first row, you can’t go backward, and you reflect this visually with a disabled control.

The end-of-set is different from the first row, so endOfSet cannot be true if atFirst( ) returns true. endOfSet is true if the row cursor is before the first row in the rowset (or after the last row).

Note

Using the rowset's navigateByMaster property to synchronize movement in master-detail rowsets, modifies the behavior of the atFirst( ) method. See navigateByMaster for more information.