Moves the current row in the result set to the row number specified and then fetches the data at that row.
sqlany_fetch_absolute ( $stmt, $row_num )
$stmt A statement object that was executed by sqlany_execute or sqlany_execute_direct.
$row_num The row number to be fetched. The first row is 1, the last row is -1.
Returns a scalar value that is 1 on success or 0 on failure.
stmt = api.sqlany_execute_direct( conn, "SELECT * FROM Employees" ) # Fetch the second row rc = api.sqlany_fetch_absolute( stmt, 2 ) 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. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |