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

 SET INDEX
 Open index file(s) in the current work area
------------------------------------------------------------------------------
 Syntax

     SET INDEX TO [<xcIndex list>]

 Arguments

     TO <xcIndex list> is a list of up to 15 index (.ntx or .ndx)
     filenames, separated by commas.  Any reference to an index filename that
     results in either a null string ("") or spaces is ignored.  You can
     specify each index file as a literal filename or as a character
     expression enclosed in parentheses.  If you specify no extension, a
     default extension is supplied by the current database driver.  (.ntx) is
     the extension supplied by the CA-Clipper driver, and (.ndx) is the
     extension supplied by the dBASE III PLUS driver.

     SET INDEX TO without an argument closes all indexes open in the current
     work area.

 Description

     SET INDEX closes all currently open index files then opens the specified
     index files in the current work area.  When more than one index file is
     opened, the first index becomes the controlling index.  The record
     pointer is initially positioned at the first logical record in the
     index.  During database file processing, all open indexes are updated
     whenever a key value is appended or changed.  To change the controlling
     index without issuing another SET INDEX command, use SET ORDER.  To add
     indexes without closing the currently opened indexes, use DBSETINDEX().

     SET INDEX is used primarily to open index files in a network environment
     instead of the INDEX clause of the USE command.  Generally, USE the
     <xcDatabase> then test to determine whether the USE succeeded.  If it
     did succeed, open the associated indexes with SET INDEX.  See the
     example below.

 Examples

     .  This example opens index files using extended expressions.
        Note how each index filename is specified by a separate variable:

        xcIndex1:= "Name"
        xcIndex2:= "Account"
        SET INDEX TO (xcIndex1), (xcIndex2)

     .  This example demonstrates using SET INDEX in a network
        environment to open indexes:

        USE Sales SHARED
        IF !NETERR()
           SET INDEX TO Sales, Territory
        ELSE
           ? "USE failed"
           BREAK
        ENDIF

 Files:  Library is CLIPPER.LIB.