Difference between revisions of "INDEXORDER()"

From Recital Documentation Wiki
Jump to: navigation, search
(Class)
 
Line 1: Line 1:
 
 
 
==Purpose==
 
==Purpose==
 
Function to return the currently selected master index number
 
Function to return the currently selected master index number
Line 30: Line 28:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 
[[Category:Indexing]]
 
[[Category:Indexing]]
 
[[Category:Indexing Functions]]
 
[[Category:Indexing Functions]]

Latest revision as of 16:32, 2 December 2009

Purpose

Function to return the currently selected master index number


Syntax

INDEXORDER([<workarea | alias>])


See Also

CLOSE INDEX, CREATE VIEW, FIND, IFILECOUNT(), INDEX, INDEXEXT(), INDEXKEY(), LOOKUP(), NDX(), ORDER(), REINDEX, RLOOKUP(), SEEK, SET CACHELOAD, SET DCACHE, SET ICACHE, SET INDEX, SET ORDER, SYS(), USE


Description

The INDEXORDER() function returns the currently selected master index number as specified with the SET ORDER TO command. If no index files are selected, it returns -1. If index file are open, and SET ORDER has been set to 0, the INDEXORDER() function returns 0. If the optional <workarea | alias> is specified, then the function will operate in that <workarea | alias>. When used in conjunction with the NDX() or INDEXKEY() functions, the INDEXORDER() function will return the index file name or index key of the master index. The INDEXORDER() function is synonymous with the ORDER() function.


Example

use patrons index name, event
? indexorder()
         1
set order to 2
? indexorder()
         2


Products

Recital Server, Recital