sqlany_get_next_result Function

Advances to the next result set in a multiple result set query.

Syntax

sqlany_get_next_result ( $stmt )

Parameters

Returns

Returns a scalar value that is 1 on success or 0 on failure.

Example

stmt = api.sqlany_prepare(conn, "call two_results()" )
rc = api.sqlany_execute( stmt )
# Fetch from first result set
rc = api.sqlany_fetch_absolute( stmt, 3 )
# Go to next result set
rc = api.sqlany_get_next_result( stmt )
# Fetch from second result set
rc = api.sqlany_fetch_absolute( stmt, 2 )