Difference between revisions of "ORDER()"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 36: Line 36:
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 +
[[Category:Indexing]]
 +
[[Category:Indexing Functions]]

Revision as of 15:08, 2 June 2009

Class

Indexing


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