Click above to get retro games delivered to your door ever month!

N_XORDER()
Set order to specified index number

Syntax
N_XORDER([<nIndex>|<cTag>])

RDD
Use SET ORDER TO or ORDSETFOCUS() or DBSETORDER()

Argument
<nIndex> is the index number to set as the active index. N_XORDER(N) sets 
the Nth index for the table as the active index. If there are not N indexes 
defined for the table then RaSQL takes no action. N_XORDER(0) specifies that 
there is no active index ("natural" order). Thus, you cannot use N_XSEEK();   
and N_XSKIP() will follow the physical record order.

Returns
N_XORDER() with no arguments, returns current active index number.
If N_XORDER(<indexN>) fails, the function returns  the number of the old 
index.

Remarks
An active index is the one that N_XSEEK will use,  and the index  N_XSKIP() 
will use to determine the next (previous) logical record. It does not imply 
that other indexes are not open: Btrieve automatically opens all indexes 
when it opens a table.

Example
N_XUSE('patients', ... )
N_XORDER(2)
N_XSEEK('Byrne', 'David')