ODBC_SQLGetDescField

4D - Documentation   Français   English   German   4D ODBC PRO, Command Theme List   4D ODBC PRO, Command Alphabetical List   Back   Previous   Next

version 2004


ODBC_SQLGetDescField (connectionID; recNumber; fieldIdentifier; valuePtr) Longint

ParameterTypeDescription
connectionIDLongintConnection ID
recNumberLongintDescriptor record number
fieldIdentifierLongintField of the descriptor whose value is to be returned
valuePtrPointerPointer to a variable to receive the descriptor
information
Function resultLongintReturns the result of the MS ODBC API function
SQLGetDescField

Description

The ODBC_SQLGetDescField command returns the current setting or value of a single field of a descriptor record.

connectionID is a valid connection ID returned by ODBC_SQLAllocConnect and a connection must be established using the ODBC_SQLConnect command.

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.

fieldIdentifier is the field of the descriptor whose value is to be returned.

valuePtr is a pointer to the variable in which to receive the descriptor information.

For more information, please see the SQLGetDescField function in the MS ODBC API at http://msdn.microsoft.com/library/en-us/odbc/htm/odbcsqlgetdescfield.asp.

Function Results

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_ERROR, SQL_NO_DATA, or SQL_INVALID_HANDLE.

SQL_NO_DATA is returned if recNumber is greater than the current number of descriptor records.

See Also

ODBC_SQLSetDescField.


4D - Documentation   Français   English   German   4D ODBC PRO, Command Theme List   4D ODBC PRO, Command Alphabetical List   Back   Previous   Next