DF_INDEX_NAME¶

Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex

Use this attribute to get the name of the index on the SQL backend that maps to the numbered index in Dataflex. This is because, unlike Dataflex, all indexes in SQL are stored as names, not numbers. Since this attribute is currently only a ReadOnly attribute, it can not be used to set or modify a named index.

This is a ReadOnly attribute

Syntax

Get_Attribute DF_INDEX_NAME of {FileNumber} {IndexNumber} to variable

Parameter

Description

FileNumber

Number of the file

IndexNumber

Number of the index

variable

Name of the index

Example

Integer iFile iIndex iIndexes

Open Orderhea
Move Orderhea.File_Number to iFile
Get_Attribute DF_FILE_LAST_INDEX_NUMBER of iFile to iIndexes

For iIndex From 0 to iIndexes
    Get_Attribute DF_INDEX_NAME of iFile iIndex to sIndexName
    Showln "Orderhea.Index." iIndex " : " sIndexName
Loop