base.SqlHandle.getResultCount

Returns the number of result set columns produced by the SQL statement.

Syntax

getResultCount()
 RETURNING count INTEGER

Usage

Call the getResultCount() method to query the number of columns in the result set, after executing the SQL statement with the open() method and fetching a row with fetch().

Example

FOR i=1 TO sh.getResultCount()
    DISPLAY sh.getResultName(i)
END FOR