4D Doc Center : ODBC

4D v13

ODBC_SQLBindCol


ODBC_SQLBindCol ( stmtID ; colNb ; targetValPtr ; strLenOrInd ) -> Function result

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 Reference at http://msdn.microsoft.com/en-us/library/ms711010(VS.85).aspx.

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.