Difference between revisions of "ORDER()"

Revision as of 11:09, 4 February 2013

Purpose

Function to return the currently selected master index number

Syntax

ORDER([<workarea | alias>])

See Also

CLOSE INDEX, IFILECOUNT(), INDEX, INDEXKEY(), KEY(), LOOKUP(), NDX(), REINDEX, RLOOKUP(), SEEK, SET INDEX, SET ORDER, SYS()

Description

The ORDER() function returns the currently selected master index number as specified with the SET ORDER TO command. If no index files are active, it returns -1.

If the workarea number or alias name <workarea | alias> is specified, then the function will operate in the required location.

Example

use patrons index name, event
? order()
         1
set order to 2
? order()
         2