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

Syntax

<oRef>.atLast( )

<oRef>

The rowset whose position you want to check.

Property of

Rowset

Description

Use atLast( ) to determine if the row cursor is at the last row in the rowset. When atLast( ) returns true, the row cursor is at the last row. atLast( ) may be an expensive operation. For example, if you have not navigated to the last row in a rowset returned by an SQL server, such a navigation would have to be attempted to determine if you are at the last row, which could be time-consuming for large rowsets.

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

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

Note

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