Difference between revisions of "ORDER()"

Revision as of 15:29, 28 October 2009

Purpose

Function to return the currently selected master index number

Syntax

ORDER([<workarea | alias>])

See Also

CLOSE INDEX, FIND, IFILECOUNT(), INDEX, INDEXKEY(), KEY(), LOOKUP(), NDX(), REINDEX, RLOOKUP(), SEEK, SET CACHELOAD, SET DCACHE, SET ICACHE, 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

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer