Skip to content

DF_DATABASE_INDEX_ASC

Can be used to set up support for the "Asc"/"Ascending" keyword when creating an index.

Level

Database

Supported by

DataFlex ODBC Driver, revision 5 and higher

Type

Boolean, temporary

Access

Read/Write

Values

  • True
  • False

Syntax

Use cli.pkg
Get_Attribute DF_DATABASE_INDEX_ASC of {driverNumber} {databaseHandle} to {BooleanVariable}
Set_Attribute DF_DATABASE_INDEX_ASC of {driverNumber} {databaseHandle} to {True|False}

Driver Configuration Keyword

Index_Asc

Remarks

Some ODBC drivers do not accurately report capabilities. A number of settings have been created to correct that problem. If a driver reports that it supports a feature it really does not support (or vice versa), errors can occur.

The DF_DATABASE_INDEX_ASC attribute can be used to set up support for the "Asc"/"Ascending" keyword when creating an index. The actual segment direction can be set using the DF_INDEX_SEGMENT_DIRECTION attribute.

Example

Procedure ShowDBAttribute Integer iDriver Handle hDatabase
    Boolean bAttribValue
    Get_Attribute DF_DATABASE_INDEX_ASC of iDriver hDatabase to bAttribValue
    Showln "Support for Ascending: " (If(bAttribValue, "YES", "NO"))
End_Procedure

The sample code above shows the current setting for a given database. The database handle can be obtained via the DF_DATABASE_ID attribute.