ORDER()
From Lianjapedia
Revision as of 11:09, 4 February 2013 by Yvonne.milne (Talk | contribs)
Contents
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