DF_DATABASE_TYPE_MAXSIZE

The maximum size of the type.

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_TYPE_MAXSIZE of {driverNumber} {databaseHandle} {typeNumber} to {IntegerVariable}

Driver Configuration Keyword

None.

Remarks

The maximum size of the type.

Several type attributes can be queried. Types are identified by the database handle and the ordinal position of the type.

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.