sqlany_fetch_next function

Returns the next row from the result set. This function first advances the row pointer and then fetches the data at the new row.

Syntax

sqlany_fetch_next ( $stmt )

Parameters

Returns

Example

stmt = api.sqlany_execute_direct( conn, "SELECT * FROM Employees" )
# Fetch the second row
rc = api.sqlany_fetch_next( stmt )
rc, employeeID = api.sqlany_get_column( stmt, 0 )
rc, managerID  = api.sqlany_get_column( stmt, 1 )
rc, surname = api.sqlany_get_column( stmt, 2 )
rc, givenName = api.sqlany_get_column( stmt, 3 )
rc, departmentID = api.sqlany_get_column( stmt, 4 )
print employeeID, ",", managerID, ",",
     surname, ",", givenName, ",", departmentID, "\n"

Discuss this page in DocCommentXchange.

sqlany_fetch_next function

Syntax

Parameters

Returns

See also

Example