返回结果集的下一行。此函数首先前移行指针，然后读取新行的数据。
sqlany_fetch_next ( $stmt )$stmt 由 sqlany_execute 或 sqlany_execute_direct 执行的语句对象。
返回标量值，成功时为 1，不成功时为 0。
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" |
| Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |