|
|
|
|
|
|
|
|
|
version 2004
ODBC_SQLSetDescRec (stmtID; recNumber; type; subType; length; precision; scale; dataPtr; stringLengthPtr; indicatorPtr) 
Longint
| 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 |
Description
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 at http://msdn.microsoft.com/library/en-us/odbc/htm/odbcsqlsetdescrec.asp.
Function Results
SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, or SQL_INVALID_HANDLE.
See Also
|
|
|
|
|
|
|
|
|