ODBC_SQLBindCol

4D - Documentation   Français   English   German   4D ODBC PRO, Command Theme List   4D ODBC PRO, Command Alphabetical List   Back   Previous   Next

version 2004


ODBC_SQLBindCol (stmtID; colNb; targetValPtr{; strLenOrInd}) Longint

ParameterTypeDescription
stmtIDLongintStatement ID
colNbLongintNumber of the result set column to bind
targetValPtrPointerPointer to the target to bind the column
strLenOrIndPointerPointer to the length/indicator buffer to bind
to the column
Function resultLongintReturns 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.


4D - Documentation   Français   English   German   4D ODBC PRO, Command Theme List   4D ODBC PRO, Command Alphabetical List   Back   Previous   Next