Full text search
function	SQLSetDescRec

Library: ODBC Include: omodbc.xin

Returns: Numeric An SQL return code. The following values may be returned: SQL_SUCCESS (the descriptor fields were successfully set). SQL_SUCCESS_WITH_INFO (the descriptor fields were successfully set, but a message was issued). SQL_ERROR (an error occurred). SQL_INVALID_HANDLE (the handle is invalid).

Declaration

  define external counter function SQLSetDescRec
     (  read-only SQL_handle_type DescriptorHandle,
        value counter RecNumber,
        value counter Type,
        value counter SubType,
        value counter Length,
        value counter Precision,
        value counter Scale,
        value counter Data,
        value counter StringLength,
        value counter Indicator)

Sets multiple descriptor fields, which affect the data type and buffer bound to a column or parameter data.

Input arguments:

• DescriptorHandle.
• RecNumber. Identifies the descriptor record containing the field the application seeks to set. Descriptor records are numbered from 0; record number 0 is the bookmark record.
• Type. The new value for the SQL_DESC_TYPE field.
• SubType. The new value for the SQL_DESC_DATETIME_INTERVAL_CODE field for SQL_DATETIME and SQL_INTERVAL type records.
• Length. The new value for the SQL_DESC_OCTET_LENGTH field.
• Precision. The new value for the SQL_DESC_PRECISION field.
• Scale. The new value for the SQL_DESC_SCALE field.
• Data. The new value for the SQL_DESC_DATA_PTR field.
• StringLength. The new value for the SQL_DESC_OCTET_LENGTH_PTR field.
• Indicator. The new value for the SQL_DESC_OCTET_LENGTH_PTR field.