base.SqlHandle.getResultName

Returns the name of a column in the result set produced by the SQL statement.

Syntax

getResultName( index INTEGER )
 RETURNING name STRING

index is the ordinal position of the result set column (starts at 1).

Usage

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

The method takes the position of the column as the parameter.

Example

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