SQL_NEXT_RESULT_SET¶

Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex

This command is used when working with SQL statements that return multiple result sets. In that scenario, calling this command will move to the next result set. That set can now be fetched or binded to columns on a table.

Syntax

SQL_NEXT_RESULT_SET [of {file}]

Parameter	Description
file	Name or number of the file (optional)

Example

SQL_SET_STMT to "SP_HELP CUSTOMER"
SQL_PREPARE_STMT
SQL_EXECUTE_STMT
SQL_FETCH_NEXT_ROW into sTable sOwner sTableType dtCreated
If (Found) Begin
    Showln sTable
    Showln sOwner
    Showln sTableType
    Showln dtCreated
End
SQL_NEXT_RESULT_SET
SQL_FETCH_NEXT_ROW into sColumnName sColumnType sComputed sLength
If (Found) Begin
    Showln sColumnName
    Showln sColumnType
    Showln sComputed
    Showln sLength
End