4D v13

ODBC_SQLBindCol

Home

 
4D v13
ODBC_SQLBindCol

ODBC_SQLBindCol 


 

ODBC_SQLBindCol ( stmtID ; colNb ; targetValPtr ; strLenOrInd ) -> Function result 
Parameter Type   Description
stmtID  Longint in Statement ID
colNb  Longint in Number of the result set column to bind
targetValPtr  Pointer in Pointer to the target to bind the column
strLenOrInd  Pointer in Pointer to the length/indicator buffer to bind to the column
Function result  Longint in Returns the result of the MS ODBC API function SQLBindCol

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.

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, or SQL_INVALID_HANDLE.

Example  

See the examples for the ODBC_SQLFetch and ODBC_SQLBulkOperations.

 
PROPERTIES 

Product: 4D
Theme: ODBC_Results
Number: 16964

 
INDEX

Alphabetical list of commands

 
HISTORY 

Created: 4D ODBC Pro 2004

 
SEE ALSO 

ODBC_LenDataAtExec
ODBC_SQLBulkOperations
ODBC_SQLFetch