ORDER( )

Topic group Related topics Example

Returns the name of the current master index.

Syntax

ORDER([<alias>])

<alias>

The work area you want to check.

Description

ORDER( ) returns the name of the current master index. For DBF tables, this could be either the name of an index tag in an .MDX file, or the name of an .NDX file (the name only, no drive or extension as returned by the NDX( ) function). For all other table types, the name is the name of an index tag.

ORDER( ) returns an empty string ("") if the table is in its natural order: either its primary key order, if it has a primary key; or no active index.

Some routines need to use a specific index. Use ORDER( ) to get the name of the current master index before switching to the desired index and then use the SET ORDER command to later restore the master index.

OODML

Check the indexName property of the Rowset object.