ODBC_SQLGetData

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

version 2004


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

ParameterTypeDescription
stmtIDLongintStatement ID
colNbLongintNumber of the column for which to return data
targetValPtrPointerPointer to a variable in which to return the data
strLenOrIndLongintLength or indicator value
Function resultLongintReturns 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 at http://msdn.microsoft.com/library/en-us/odbc/htm/odbcsqlgetdata.asp.

Function Results

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

See Also

ODBC_SQLFetchScroll.


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