Επεξεργασία

Κοινή χρήση μέσω


Row Status Array

In addition to data, SQLFetch and SQLFetchScroll can return an array that gives the status of each row in the rowset. This array is specified through the SQL_ATTR_ROW_STATUS_PTR statement attribute. This array is allocated by the application and must have as many elements as are specified by the SQL_ATTR_ROW_ARRAY_SIZE statement attribute. The values in the array are set by SQLBulkOperations, SQLFetch, SQLFetchScroll, and SQLSetPos. The values describe the status of the row and whether that status has changed since it was last fetched.

Row status array value Description
SQL_ROW_SUCCESS The row was successfully fetched and has not changed since it was last fetched.
SQL_ROW_SUCCESS_WITH_INFO The row was successfully fetched and has not changed since it was last fetched. However, a warning was returned about the row.
SQL_ROW_ERROR An error occurred while fetching the row.
SQL_ROW_UPDATED The row was successfully fetched and has been updated since it was last fetched. If the row is fetched again or refreshed by SQLSetPos, its status is changed to the new status.

Some drivers cannot detect changes to data and therefore cannot return this value. To determine whether a driver can detect updates to refetched rows, an application calls SQLGetInfo with the SQL_ROW_UPDATES option.
SQL_ROW_DELETED The row has been deleted since it was last fetched.
SQL_ROW_ADDED The row was inserted by SQLBulkOperations. If the row is fetched again or is refreshed by SQLSetPos, its status is SQL_ROW_SUCCESS.

This value is not set by SQLFetch or SQLFetchScroll.
SQL_ROW_NOROW The rowset overlapped the end of the result set, and no row was returned that corresponded to this element of the row status array.