4D v14.1ODBC_SQLSetDescRec |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
4D v14.1
ODBC_SQLSetDescRec
|
ODBC_SQLSetDescRec ( stmtID ; recNumber ; type ; subType ; length ; precision ; scale ; dataPtr ; stringLengthPtr ; indicatorPtr ) -> Function result | ||||||||
Parameter | Type | Description | ||||||
stmtID | Longint |
![]() |
Statement ID | |||||
recNumber | Integer |
![]() |
Descriptor record number | |||||
type | Integer |
![]() |
SQL_DESC_TYPE field for the descriptor record | |||||
subType | Integer |
![]() |
SQL_DESC_DATETIME_INTERVAL_CODE field for the descriptor record | |||||
length | Integer |
![]() |
SQL_DESC_OCTET_LENGTH field for the descriptor record | |||||
precision | Integer |
![]() |
SQL_DESC_PRECISION field for the descriptor record | |||||
scale | Integer |
![]() |
SQL_DESC_SCALE field for the descriptor record | |||||
dataPtr | Pointer |
![]() |
SQL_DESC_DATA_PTR field for the descriptor record | |||||
stringLengthPtr | Pointer |
![]() |
SQL_DESC_OCTET_LENGTH_PTR field for the descriptor record | |||||
indicatorPtr | Pointer |
![]() |
SQL_DESC_INDICATOR_PTR field for the descriptor record | |||||
Function result | Longint |
![]() |
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.
Product: 4D
Theme: ODBC_Results
Number:
16949
Created: 4D ODBC Pro 2004
4D ODBC Pro ( 4D ODBC Pro v11.4)
4D ODBC Pro ( 4D ODBC Pro v12)
4D ODBC Pro ( 4D v13)
4D ODBC Pro ( 4D v14 R3)
4D ODBC Pro ( 4D v14.1)
4D ODBC Pro ( 4D v14 R2)
4D ODBC Pro ( 4D v14 R4)