ORDER()

From Lianjapedia
Revision as of 06:00, 10 February 2012 by Yvonne.milne (Talk | contribs)

Jump to: navigation, search

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