base.SqlHandle.fetchFirst
Fetches the first row in a scrollable SQL result set.
Syntax
fetchFirst()
Usage
Call the fetchFirst()
method to fetch the first row in a scrollable SQL result
set.
The SQL statement must have been opened with an openScrollCursor()
or
openScrollCursorWithHold()
.
After performing the fetch call, you can query for column information
with the getResultCount()
, getResultName(index)
, getResultType(index)
and getResultValue(index)
methods.
If the result set is empty, or if the current row is already the first row,
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.fetchFirst()
For a complete example, see Example 4: SqlHandle with scroll cursor.