4D v13

ODBC_SQLSetDescRec

Home

 
4D v13
ODBC_SQLSetDescRec

ODBC_SQLSetDescRec 


 

ODBC_SQLSetDescRec ( stmtID ; recNumber ; type ; subType ; length ; precision ; scale ; dataPtr ; stringLengthPtr ; indicatorPtr ) -> Function result 
Parameter Type   Description
stmtID  Longint in Statement ID
recNumber  Integer in Descriptor record number
type  Integer in SQL_DESC_TYPE field for the descriptor record
subType  Integer in SQL_DESC_DATETIME_INTERVAL_CODE field for the descriptor record
length  Integer in SQL_DESC_OCTET_LENGTH field for the descriptor record
precision  Integer in SQL_DESC_PRECISION field for the descriptor record
scale  Integer in SQL_DESC_SCALE field for the descriptor record
dataPtr  Pointer in SQL_DESC_DATA_PTR field for the descriptor record
stringLengthPtr  Pointer in SQL_DESC_OCTET_LENGTH_PTR field for the descriptor record
indicatorPtr  Pointer in SQL_DESC_INDICATOR_PTR field for the descriptor record
Function result  Longint in Returns the result of the MS ODBC API function SQLSetDescRec

The ODBC_SQLSetDescRec command sets multiple descriptor fields that affect the data type and buffer bound to a column or parameter data.

StmtID is a valid statement ID returned by ODBC_SQLAllocStmt.

Descriptor records are numbered from 1, with recNumber equal to 0 being the bookmark record. The recNumber argument must be less than or equal to the value of SQL_DESC_COUNT. If recNumber is less than or equal to SQL_DESC_COUNT but the row does not contain data for a column or parameter, a call to ODBC_SQLSetDescRec will return the default values of the fields.

recNumber is the descriptor record number.

type is the SQL_DESC_TYPE field for the descriptor record.

subType is the SQL_DESC_DATETIME_INTERVAL_CODE field for the descriptor record (for records whose type is SQL_DATETIME or SQL_INTERVAL).

length is the SQL_DESC_OCTET_LENGTH field for the descriptor record.

precision is the SQL_DESC_PRECISION field for the descriptor record.

scale is the SQL_DESC_SCALE field for the descriptor record.

dataPtr is the SQL_DESC_DATA_PTR field for the descriptor record.

stringLengthPtr is the SQL_DESC_OCTET_LENGTH_PTR field for the descriptor record.

indicatorPtr is the SQL_DESC_OCTET_INDICATOR_PTR field for the descriptor record.

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

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, or SQL_INVALID_HANDLE.

 
PROPERTIES 

Product: 4D
Theme: ODBC_Results
Number: 16949

 
INDEX

Alphabetical list of commands

 
HISTORY 

Created: 4D ODBC Pro 2004

 
SEE ALSO 

ODBC_SQLGetDescRec