4D v13
ODBC_SQLGetDescRec
- 4D ODBC Pro
-
- ODBC_Results
-
- Retrieving Results and Information, Introduction
- ODBC_SQLBindCol
- ODBC_SQLBulkOperations
- ODBC_SQLColAttribute
- ODBC_SQLDescribeCol
- ODBC_SQLFetch
- ODBC_SQLFetchScroll
- ODBC_SQLGetData
- ODBC_SQLGetDescField
- ODBC_SQLGetDescRec
- ODBC_SQLGetDiagField
- ODBC_SQLGetDiagRec
- ODBC_SQLMoreResults
- ODBC_SQLNumResultCols
- ODBC_SQLRowCount
- ODBC_SQLSetDescField
- ODBC_SQLSetDescRec
- ODBC_SQLSetPos
ODBC_SQLGetDescRec
| ODBC_SQLGetDescRec ( stmtID ; recNumber ; name ; type ; subType ; length ; precision ; scale ; nullable ) -> Function result | ||||||||
| Parameter | Type | Description | ||||||
| stmtID | Longint |
|
Statement ID | |||||
| recNumber | Integer |
|
Descriptor record number | |||||
| name | String |
|
SQL_DESC_NAME field for the descriptor record | |||||
| type | Longint |
|
SQL_DESC_TYPE field for the descriptor record | |||||
| subType | Longint |
|
SQL_DESC_DATETIME_INTERVAL_CODE field for the descriptor record | |||||
| length | Longint |
|
SQL_DESC_OCTET_LENGTH field for the descriptor record | |||||
| precision | Longint |
|
SQL_DESC_PRECISION field for the descriptor record | |||||
| scale | Longint |
|
SQL_DESC_SCALE field for the descriptor record | |||||
| nullable | Longint |
|
SQL_DESC_NULLABLE field for the descriptor record | |||||
| Function result | Longint |
|
Returns the result of the MS ODBC API function SQLGetDescRec | |||||
The ODBC_SQLGetDescRec command returns the current settings or values of multiple fields of a descriptor record. The fields returned describe the name, data type, and storage of column or parameter data.
StmtID is a valid statement ID returned by ODBC_SQLAllocStmt.
Descriptor records are numbered from 0, with record number 0 being the bookmark record. If the fieldIdentifier argument indicates a header field, recNumber is ignored. 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_SQLGetDescField will return the default values of the fields.
recNumber is the descriptor record number.
name is the SQL_DESC_NAME field for the descriptor record.
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.
nullable is the SQL_DESC_NULLABLE field for the descriptor record.
For more information, please see the SQLGetDescRec function in the MS ODBC API Reference at http://msdn.microsoft.com/en-us/library/ms710921(VS.85).aspx.
SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_NO_DATA, SQL_ERROR, or SQL_INVALID_HANDLE.
Product: 4D
Theme: ODBC_Results
Number:
16956
Created: 4D ODBC Pro 2004
