4D v16

ODBC_SQLGetDescRec

Página Inicial

 
4D v16
ODBC_SQLGetDescRec

ODBC_SQLGetDescRec 


 

ODBC_SQLGetDescRec ( stmtID ; recNumber ; nome ; tipo ; subType ; longitude ; precision ; scale ; nullable ) -> Resultado 
Parâmetro Tipo   Descrição
stmtID  Inteiro longo in Statement ID
recNumber  Inteiro in Descriptor record number
nome  String in SQL_DESC_NAME field for the descriptor record
tipo  Inteiro longo in SQL_DESC_TYPE field for the descriptor record
subType  Inteiro longo in SQL_DESC_DATETIME_INTERVAL_CODE field for the descriptor record
longitude  Inteiro longo in SQL_DESC_OCTET_LENGTH field for the descriptor record
precision  Inteiro longo in SQL_DESC_PRECISION field for the descriptor record
scale  Inteiro longo in SQL_DESC_SCALE field for the descriptor record
nullable  Inteiro longo in SQL_DESC_NULLABLE field for the descriptor record
Resultado  Inteiro longo in 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.



Ver também 

ODBC_SQLSetDescRec

 
PROPRIEDADES 

Produto: 4D
Tema: ODBC_Results
Número 16956

 
HISTÓRIA 

Criado por: 4D ODBC Pro 2004

 
ARTICLE USAGE

4D ODBC Pro ( 4D v16)