Related Syntax		Other Library Functions

function

SQLGetTypeInfo

Library: omodbc - low-level ODBC support Include: omodbc.xin

Return type: Integer Returns:        An SQL return code. The following values may be returned: SQL_SUCCESS (the data type information was retrieved). SQL_SUCCESS_WITH_INFO (the data type information was retrieved, but a message was issued). SQL_ERROR (an error occurred). SQL_INVALID_HANDLE (the handle is invalid). SQL_STILL_EXECUTING (the program is still executing).

Declaration

  define external integer function SQLGetTypeInfo
     (  read-only SQL_handle_type StatementHandle,
        value integer DataType )

Returns information about data types supported by the data source in the form of an SQL result set. The data types are intended for use in Data Definition Language (DDL) statements.

Important: Applications must use the type names returned in the TYPE_NAME column in ALTER TABLE and CREATE TABLE statements. The SQLGetTypeInfo function may return more than one row with the same value in the DATA_TYPE column.

Input arguments:

1. StatementHandle.
2. DataType. The SQL data type. The following values are allowed:
   • SQL_ALL_TYPES (requests all data types)
   • SQL_UNKNOWN_TYPE
   • SQL_CHAR
   • SQL_NUMERIC
   • SQL_DECIMAL
   • SQL_INTEGER
   • SQL_SMALLINT
   • SQL_FLOAT
   • SQL_REAL
   • SQL_DOUBLE
   • SQL_DATETIME
   • SQL_VARCHAR