DF_DATABASE_TYPE_UNSIGNED

Indicates if the type is unsigned (true) or not (false).

Level

Database

Supported by

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

Type

Boolean, temporary.

Access

Read Only.

Values

• True
• False

Syntax

Use cli.pkg
Get_Attribute DF_DATABASE_TYPE_UNSIGNED of {driverNumber} {databaseHandle} {typeNumber} to {BooleanVariable}

Driver Configuration Keyword

None.

Remarks

Indicates if the type is unsigned (true) or not (false).

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.