version 2004
ODBC_SQLBindCol (stmtID; colNb; targetValPtr{; strLenOrInd}) Longint
Parameter | Type | Description | |
stmtID | Longint | Statement ID | |
colNb | Longint | Number of the result set column to bind | |
targetValPtr | Pointer | Pointer to the target to bind the column | |
strLenOrInd | Pointer | Pointer to the length/indicator buffer to bind | |
to the column | |||
Function result | Longint | Returns the result of the MS ODBC API function | |
SQLBindCol |
Description
The ODBC_SQLBindCol command binds application data buffers to columns in the result set.
stmtID is a valid statement ID returned by ODBC_SQLAllocStmt.
colNB is the number of the result set column to bind. Columns are numberes in increasing column
order starting at 0, where the column 0 is the bookmark column.
targetValuePtr is a pointer to the variable, 4D field or array to bind to the column.
strLenOrInd is an optional parameter that is a pointer to the length of the parameter, which is a Longint, if paramType is of type Text, Picture, or BLOB. Use the ODBC_LenDataAtExec command to convert the actual length so that it can be processed by the MS ODBC API.
For more information, please see the SQLBindCol function in the MS ODBC API at http://msdn.microsoft.com/library/en-us/odbc/htm/odbcsqlbindcol.asp.
Function Results
SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, or SQL_INVALID_HANDLE.
Example
See the examples for the ODBC_SQLFetch and ODBC_SQLBulkOperations.
See Also
ODBC_LenDataAtExec, ODBC_SQLBulkOperations, ODBC_SQLFetch.