base.SqlHandle.fetchLast

Fetches the last row in a scrollable SQL result set.

Syntax

fetchLast()

Usage

Call the fetchLast() method to fetch the last row in a scrollable SQL result set.

The SQL statement must have been opened with a openScrollCursor() call.

After performing the fetch call, you can query for column information with the getResultCount(), getResultName(index), getResultType(index) and getResultValue(index) methods.

If no row is found (end of result set), SQLCA.SQLCODE is set to 100 (NOTFOUND).

If the result set is empty, SQLCA.SQLCODE is set to 100 (NOTFOUND).

As with standard Genero SQL instructions, SQL errors can be trapped with WHENEVER ERROR or TRY / CATCH blocks and by testing SQLCA.SQLCODE.

Example

DEFINE sh base.SqlHandle
...
CALL sh.fetchLast()

For a complete example, see Example 4: SqlHandle with scroll cursor.