DF_DATABASE_NUMBER_TYPES

The number of types available in the database.

Level

Database

Supported by

The DataFlex SQL Drivers (SQL Server, DB2, and ODBC), revision 5 and higher.

Type

Integer, temporary

Access

Read Only

Values

0..

Syntax

Use cli.pkg
Get_Attribute DF_DATABASE_NUMBER_TYPES of {driverNumber} {databaseHandle} to {IntegerVariable}

Driver Configuration Keyword

None

Remarks

This attribute returns the number of types available in the database. Databases are identified by a handle; this handle should be acquired by the DF_DATABASE_ID or DF_FILE_DATABASE_ID attribute.

The sample code below shows type attributes of all types in a database.

Procedure ShowTypes Integer iDriver Handle hDatabase
    Integer iNumTypes
    Integer iType
    String sTypeName
    Handle hTypeID
    Boolean bAutoinc
    Boolean bUnsigned
    Integer iMaxSize
    String sCreateParams

    Get_Attribute DF_DATABASE_NUMBER_TYPES of iDriver hDatabase to iNumTypes

    For iType from 0 to (iNumTypes - 1)
        Get_Attribute DF_DATABASE_TYPE_NAME        Of iDriver hDatabase iType To sTypeName
        Get_Attribute DF_DATABASE_TYPE_ID          Of iDriver hDatabase iType To hTypeID
        Get_Attribute DF_DATABASE_TYPE_AUTOINC     Of iDriver hDatabase iType To bAutoinc
        Get_Attribute DF_DATABASE_TYPE_UNSIGNED     Of iDriver hDatabase iType To bUnsigned
        Get_Attribute DF_DATABASE_TYPE_MAXSIZE     Of iDriver hDatabase iType To iMaxSize
        Get_Attribute DF_DATABASE_TYPE_CREATE_PARAMS Of iDriver hDatabase iType To sCreateParams

        Showln "  " iType ", " sTypeName ", " hTypeID ", " (If(bAutoinc, "Auto Increment", "NO Auto Increment")) ", " ;
        (If(bUnsigned, "Unsigned", "Signed")) ", " iMaxSize ", " sCreateParams
    Loop
End_Procedure // ShowTypes

The database handle can be obtained via the DF_DATABASE_ID attribute.