![]() ![]() The data returned for a column was truncated. (If this SQLSTATE is returned when an ODBC 3*.x* application is working with an ODBC 2*.x* driver, it can be ignored.) If it was a string value, it was right-truncated.Īn error occurred while fetching one or more rows. String or binary data returned for a column resulted in the truncation of nonblank character or non-NULL binary data. (Function returns SQL_SUCCESS_WITH_INFO.) ![]() SQLSTATEĭriver-specific informational message. If an error occurs on a single column, SQLGetDiagField can be called with a DiagIdentifier of SQL_DIAG_COLUMN_NUMBER to determine the column the error occurred on and SQLGetDiagField can be called with a DiagIdentifier of SQL_DIAG_ROW_NUMBER to determine the row that contains that column.įor all those SQLSTATEs that can return SQL_SUCCESS_WITH_INFO or SQL_ERROR (except 01xxx SQLSTATEs), SQL_SUCCESS_WITH_INFO is returned if an error occurs on one or more, but not all, rows of a multirow operation, and SQL_ERROR is returned if an error occurs on a single-row operation. The return code associated with each SQLSTATE value is SQL_ERROR, unless noted otherwise. The following table lists the SQLSTATE values typically returned by SQLFetch and explains each one in the context of this function the notation "(DM)" precedes the descriptions of SQLSTATEs returned by the Driver Manager. When SQLFetch returns either SQL_ERROR or SQL_SUCCESS_WITH_INFO, an associated SQLSTATE value can be obtained by calling SQLGetDiagRec Function with a HandleType of SQL_HANDLE_STMT and a Handle of StatementHandle. SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_NO_DATA, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE. SQLFetch fetches the next rowset of data from the result set and returns data for all bound columns. Version Introduced: ODBC 1.0 Standards Compliance: ISO 92 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |