DF_DATABASE_INDEX_DROP

Can be used to setup support for dropping (deleting) 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_DROP of {driverNumber} {databaseHandle} to {BooleanVariable}

Set_Attribute DF_DATABASE_INDEX_DROP of {driverNumber} {databaseHandle} to {True|False}

Driver Configuration Keyword

Index_Drop

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 support a feature it really does not support (or vice versa), errors can occur.

The DF_DATABASE_INDEX_DROP attribute can be used to setup support for dropping (deleting) an index. The actual removal of the index can be performed using the Delete_Index command.

Procedure ShowDBAttribute Integer iDriver Handle hDatabase

    Boolean bAttribValue

    Get_Attribute DF_DATABASE_INDEX_DROP of iDriver hDatabase to bAttribValue      

    Showln "Support for dropping an index: " (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.