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

N_XAMAKENDX()
Add a supplemental index to a table

Syntax
N_XAMAKENDX(<cName>, <aIndex> | <cIndex>)

RDD Option
INDEX ON or DBCREATEINDEX()

Arguments
<cName> is ignored by RaSQL/B.  You may leav it blank.  It is used only by 
RaSQL/X.

<Index> is an array or string containing the index definition.  See Appendix 
C for the structure of this parameter.

Returns
True if successful. False on failure. Use N_XERROR() to get an error code.

Remarks
Creates a supplemental index from an array or string argument. 

N_XAMAKENDX() works similarly to N_XMAKENDX(), except that the latter uses 
an extended structure DBF as input. As with N_XMAKENDX(), you can create 
only one index for each call to N_XAMAKENDX().

Examples
* Create supplemental index of
* LNAME + FNAME. Index is unique
* and static.
DECLARE index[2]
index[1] = 'LNAME               X    dMNqsU;'
*           FFFFFFFFFFFFFFFFFFFFXXbbbDMNQSU;
index[2] = 'FNAME              X    dmNqsU;'
N_XUSE('patients.dta', ...)  && Table must
N_XAMAKENDX('', index)       && be open

* Same as above, with string argument.
N_XUSE('patients.dta', ...)
N_XAMAKENDX('', ;
   'LNAME               X    dMNqsU;' ;
 + 'FNAME               X    dmNqsU;' )