Difference between revisions of "ORDER()"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision) |
Yvonne.milne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return the currently selected master index number | Function to return the currently selected master index number | ||
| − | |||
==Syntax== | ==Syntax== | ||
ORDER([<workarea | alias>]) | ORDER([<workarea | alias>]) | ||
| − | |||
==See Also== | ==See Also== | ||
| − | [[CLOSE INDEX | + | [[CLOSE INDEX]], [[IFILECOUNT()]], [[INDEX]], [[INDEXKEY()]], [[KEY()]], [[LOOKUP()]], [[NDX()]], [[REINDEX]], [[RLOOKUP()]], [[SEEK]], [[SET INDEX]], [[SET ORDER]], [[SYS()]] |
| − | + | ||
==Description== | ==Description== | ||
| Line 15: | Line 12: | ||
If the workarea number or alias name <workarea | alias> is specified, then the function will operate in the required location. | If the workarea number or alias name <workarea | alias> is specified, then the function will operate in the required location. | ||
| − | |||
==Example== | ==Example== | ||
| Line 27: | Line 23: | ||
</code> | </code> | ||
| − | |||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:Indexing]] | [[Category:Indexing]] | ||
[[Category:Indexing Functions]] | [[Category:Indexing Functions]] | ||
Revision as of 06:00, 10 February 2012
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
