4D v16

ODBC_SQLGetData

Home

 
4D v16
ODBC_SQLGetData

ODBC_SQLGetData 


 

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

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.

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



See also 

ODBC_SQLFetchScroll

 
PROPERTIES 

Product: 4D
Theme: ODBC_Results
Number: 16958

 
HISTORY 

Created: 4D ODBC Pro 2004

 
ARTICLE USAGE

4D ODBC Pro ( 4D v16)