MDAC 2.5 SDK - ODBC Programmer's Reference
Chapter 11: Retrieving Results (Advanced)
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. |