Difference between revisions of "ORDER()"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
| 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== | ||
| Line 9: | Line 9: | ||
==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. | ||
| Line 15: | Line 15: | ||
==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> | ||
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
