Retrieving Results and Information, Introduction

4D v16

The commands in this chapter enable you to retrieve results and information about the results, by allowing you to do the following:

Bind application data buffers to columns in the result set (ODBC_SQLBindCol)
Perform bulk insertions and bulk bookmark operations, including update, delete, and fetch by bookmark (ODBC_SQLBulkOperations)
Get the descriptor information for a column in a result set (ODBC_SQLColAttribute)
Retrieve the result descriptor, such as column name, type, column size, decimal digits, and nullability, for one column in the result set (ODBC_SQLDescribeCol)
Fetch the next rowset of data from the result set and returns data for all bound columns (ODBC_SQLFetch)
Fetch the specified rowset of data from the result set and returns data for all bound columns (ODBC_SQLFetchScroll)
Get data for a single column in the result set (ODBC_SQLGetData)
Get the current setting or value of a single field of a descriptor record (ODBC_SQLGetDescField)
Get the current settings or values of multiple fields of a descriptor record (ODBC_SQLGetDescRec)
Get the current value of a field of a record of the diagnostic data structure (associated with a specified handle) that contains error, warning, and status information (ODBC_SQLGetDiagField)
Get the current values of multiple fields of a diagnostic record that contains error, warning, and status information (ODBC_SQLGetDiagRec)
Determine whether more results are available on a statement containing SELECT, UPDATE, INSERT or DELETE statements and, if so, initializes processing for those results (ODBC_SQLGetMoreResults)
Find out the number of columns in a result set (ODBC_SQLNumResultCols)
Get the number of rows affected by an UPDATE, INSERT, or DELETE statement (ODBC_SQLRowCount)
Set the current setting or value of a single field of a descriptor record (ODBC_SQLSetDescField)
Set the current settings or values of multiple fields of a descriptor record (ODBC_SQLSetDescRec)
Set the cursor position in a rowset and allows an application to refresh data in the rowset or to update or delete data in the result set (ODBC_SQLSetPos)