base.SqlHandle.getResultCount

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

Syntax

getResultCount()
 RETURNS 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

DEFINE sh base.SqlHandle, i INT
...
FOR i=1 TO sh.getResultCount()
    DISPLAY sh.getResultName(i)
END FOR

For a complete example, see Example 2: SqlHandle with result set SQL.