+---------------------------------+
|              ORDER              |
+---------------------------------+
ORDER([<expN1> | <expC>
        [, <expN2>]])

-----------------------------------
Returns name of master index or master tag.
Return value - Character
-----------------------------------

A database may have several index files open simultaneously.  However,
only one .IDX index file (the master index file) or tag from a .CDX
compound index file (the master tag) controls the order in which the
database is displayed or accessed.  Certain commands (SEEK for example)
use the master index file or master tag to search for records.  This
function returns the name of the master index file or master tag.

USE and SET INDEX both support an index file list that opens index files
for a database.  A master index file or master tag can be designated in
this index file list. SET ORDER can also be used to designate a master
index or master tag.

<expN1> | <expC>
        ORDER() returns the master index file name or master tag name for the
currently selected work area.

        You can return the master index file name or master tag name from other
unselected work areas by specifying the work area number <expN1>, or the
database alias <expC>.

        If a database doesn't have the alias you specify, the message "Alias
not found" is displayed.

<expN2>
        If a database has a master index file or tag and the optional numeric
argument <expN2> is included, the name of the master .IDX file or .CDX
file that contains the master tag is returned.  The drive and directory
is returned along with the .IDX or .CDX file name.  The numeric
expression <expN2> can have any value.

+---------------------------------+
|         Program Example         |
+---------------------------------+
CLOSE ALL
SELECT 0
USE items
SELECT 0
USE customer ORDER cust_id
? ORDER()

? ORDER('customer', 1)

SET ORDER TO company
WAIT WINDOW 'Master index: ' + ORDER() NOWAIT
? ORDER('items') && null string returned

-----------------------------------

See Also:  INDEX, SET INDEX, SET ORDER, USE

-----------------------------------