Difference between revisions of "INDEXORDER()"
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== | ||
INDEXORDER([<workarea | alias>]) | INDEXORDER([<workarea | alias>]) | ||
− | |||
==See Also== | ==See Also== | ||
− | [[CLOSE INDEX]], [[CREATE VIEW | + | [[CLOSE INDEX]], [[CREATE VIEW]], [[IFILECOUNT()]], [[INDEX]], [[INDEXEXT()]], [[INDEXKEY()]], [[LOOKUP()]], [[NDX()]], [[ORDER()]], [[REINDEX]], [[RLOOKUP()]], [[SEEK]], [[SET INDEX]], [[SET ORDER]], [[SYS()]], [[USE]] |
− | + | ||
==Description== | ==Description== | ||
− | The INDEXORDER() function returns the currently selected master index | + | The INDEXORDER() 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== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
− | use | + | open database southwind |
+ | use customers | ||
+ | set order tag companyname_search | ||
? indexorder() | ? indexorder() | ||
− | + | 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
INDEXORDER([<workarea | alias>])
See Also
CLOSE INDEX, CREATE VIEW, IFILECOUNT(), INDEX, INDEXEXT(), INDEXKEY(), LOOKUP(), NDX(), ORDER(), REINDEX, RLOOKUP(), SEEK, SET INDEX, SET ORDER, SYS(), USE
Description
The INDEXORDER() 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 ? indexorder() companyname_search