SQLFETCH

The SQLFETCH function retrieves one or more rows of a column in a relational text.

Return value

TEXT

Syntax

SQLFETCH (cursorname [COLUMN column-number} {STOPAFTER number-of-rows])

Parameters

cursorname: A TEXT expression that is the name of the SQL cursor. The cursor must be opened and closed by the caller.
column-number: An INTEGER value that is the number of the column. (Default is 1.)
number-of-rows: The number of rows to read. (Default is all remaining rows).