Difference between revisions of "ORDER()"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision) |
Yvonne.milne (Talk | contribs) |
||
(2 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
− | Function to return the currently selected master index | + | Function to return the name of the currently selected master index |
− | + | ||
==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== | ||
− | The ORDER() function returns the currently selected master index | + | The ORDER() function returns the name of the currently selected master index: single index file basename or tag tagname. If no master index is active, it returns an empty string. |
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== | ||
<code lang="recital"> | <code lang="recital"> | ||
− | use | + | open database southwind |
+ | use customers | ||
+ | set order tag companyname_search | ||
? order() | ? order() | ||
− | + | companyname_search | |
− | + | ||
− | + | ||
− | + | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
− | [[Category: | + | [[Category:Cursor Functions]] |
− | [[Category: | + | [[Category:Search Functions]] |
Latest revision as of 08:28, 30 May 2013
Contents
Purpose
Function to return the name of the currently selected master index
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 name of the currently selected master index: single index file basename or tag tagname. If no master index is active, it returns an empty string.
If the workarea number or alias name <workarea | alias> is specified, then the function will operate in the required location.
Example
open database southwind use customers set order tag companyname_search ? order() companyname_search