ORDER()

From Lianjapedia
Revision as of 07:28, 30 May 2013 by Yvonne.milne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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