solidDB Help : solidDB reference : ODBC: Functions : Retrieving results and information about results
  
Retrieving results and information about results
SQLRowCount
Returns the number of rows affected by an UPDATE, INSERT, or DELETE statement.
Version introduced: 1.0
Availability when using ODBC: Supported
Conformance: ISO 92
SQLNumResultCols
Returns the number of columns in a result set.
Version introduced: 1.0
Availability when using ODBC: Supported
Conformance: ISO 92
SQLDescribeCol
Returns the result descriptor (column name, type, column size, decimal digits, and nullability) for one column in the result set. This information is also available in the fields of the IRD.
The driver now returns the number of characters instead of the number of bytes for the following attributes: SQL_DESC_LABEL, SQL_DESC_NAME, SQL_DESC_SCHEMA_NAME, SQL_DESC_CATALOG_NAME, SQL_DESC_BASE_COLUMN_NAME, and SQLDESC_BASE_TABLE_NAME
This conforms more closely to the ODBC standard and works correctly using ADO, VB, OLE-DB, and ODBC calls. Note, however, that this causes failure of the Microsoft Visual DataBase Project. After updating/inserting the record, the record is not saved and the following error is displayed: "the table does not exist".
Version introduced: 1.0
Availability when using ODBC: Supported.
Conformance: ISO 92
SQLColAttributes
N/A
Version introduced: 1.0
Availability when using ODBC: Deprecated (replaced by SQLColAttribute)
Conformance: N/A
SQLColAttribute
Describes attributes of a column in the result set.
The driver now returns the number of characters instead of the number of bytes for the following attributes: SQL_DESC_LABEL, SQL_DESC_NAME, SQL_DESC_SCHEMA_NAME, SQL_DESC_CATALOG_NAME, SQL_DESC_BASE_COLUMN_NAME, and SQLDESC_BASE_TABLE_NAME
This conforms more closely to the ODBC standard and works correctly using ADO, VB, OLE-DB, and ODBC calls. Note, however, that this causes failure of the Microsoft Visual DataBase Project. After updating/inserting the record, the record is not saved and the following error is displayed: "the table does not exist."
Version introduced: 3.0
Availability when using ODBC: Supported.
Conformance: ISO 92
SQLBindCol
Assigns storage for a result column and specifies the data type.
Version introduced: 1.0
Availability when using ODBC: Supported
Conformance: ISO 92
SQLFetch
Returns multiple result rows, fetching the next rowset of data from the result set and returning data for all bound columns.
SQLSetCursorName
Version introduced: 1.0
Availability when using ODBC: Supported
Conformance: ISO 92
SQLExtendedFetch
N/A
Version introduced: 2.0
Availability when using ODBC: Replaced by SQLFetchScroll
Conformance: N/A
SQLFetchScroll
Returns scrollable result rows, fetching the specified rowset of data from the result set and returning data for all bound columns. Block cursor support enables an application to fetch more than one row with a single fetch into the application buffer.
When working with an ODBC 2.x driver, the Driver Manager maps this function to SQLExtendedFetch.
Version introduced: 3.0
Availability when using ODBC: Supported
Since the solidDB ODBC Driver currently has no support for bookmarks, it is not possible to support the SQL_FETCH_BOOKMARK option in SQLFetchScroll.
Conformance: ISO 92
SQLGetData
Returns part or all of one column of one row of a result set. It can be called multiple times to retrieve variable length data in parts, making it useful for long data values.
Version introduced: 1.0
Availability when using ODBC: Supported
Conformance: ISO 92
SQLSetPos
Positions a cursor within a fetched block of data and allows an application to refresh data in the rowset or to update or delete data in the result set.
Version introduced: 1.0
Availability when using ODBC: Supported, along with all the options, that is, SQL_POSITION, SQL_DELETE, and SQL_UPDATE
Conformance: ODBC
SQLBulkOperations
Performs bulk insertions and bulk bookmark operations, including update, delete, and fetch by bookmark.
Version introduced: 3.0
Availability when using ODBC: solidDB supports this, but only when using the SQL_ADD option.
Conformance: ODBC
SQLMoreResults
Determines whether there are more results available on a statement containing SELECT, UPDATE, INSERT, or DELETE statement and, if so, initializes processing for those results.
Version introduced: 1.0
Availability when using ODBC: Not supported
solidDB does not support multiple results.
Conformance: ODBC
SQLGetDiagField
Returns additional diagnostic information (a single field of the diagnostic data structure associated with a specified handle). This information includes error, warning, and status information.
Version introduced: 3.0
Availability when using ODBC: Supported
Conformance: ISO 92
SQLGetDiagRec
Returns additional diagnostic information (multiple fields of the diagnostic data structure). Unlike SQLGetDiagField, which returns one diagnostic field per call, SQLGetDiagRec returns several commonly used fields of a diagnostic record, including the SQLSTATE, the native error code, and the diagnostic message text.
Version introduced: 3.0
Availability when using ODBC: Supported
Conformance: ISO 92
SQLError
N/A
Version introduced: 1.0
Availability when using ODBC: Deprecated (replaced by SQLGetDiagRec)
Conformance: N/A
Go up to
ODBC: Functions