4D Doc Center : ODBC

Home

4D v14.1

ODBC_SQLGetData


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

Parameter	Type	Description
stmtID	Longint	Statement ID
colNb	Longint	Number of the column for which to return data
targetValPtr	Pointer	Pointer to a variable in which to return the data
strLenOrInd	Longint	Length or indicator value
Function result	Longint	Returns the result of the MS ODBC API function SQLGetData

Description

The ODBC_SQLGetData command retrieves data for a single column defined by colNb in the result set. It can be called multiple times to retrieve variable-length data in parts.

stmtID is a valid statement ID returned by ODBC_SQLAllocStmt.

colNb is the number of the column to receive the data.

targetValPtr is a pointer to the variable in which to return the data.

strLenOrInd is the length or indicator value of the value returned in targetValPtr.

For more information, please see the SQLGetData function in the MS ODBC API Reference at http://msdn.microsoft.com/en-us/library/ms715441(VS.85).aspx.

Function Results

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_NO_DATA, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.