4D Doc Center : Retrieving Results and Information, Introduction

4D v13

Retrieving Results and Information, Introduction

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)