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

SET INDEX


Syntax:     SET INDEX TO [<file list>/(<expC1>),...]

Purpose:    To open the specified index file(s) in the current work
            area.

Argument:   <file list> are the names of one or more (up to 15)
            index (.ntx or .ndx) files, separated by commas.  The
            filename may be specified preceded by a drive letter and/or
            path name.  The (.ntx) or (.ndx) extension is assumed unless
            otherwise specified.

            SET INDEX TO without a filename closes all indexes open in
            the current work area.

Usage:      When more than one index file is opened for the active
            database file, 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.

            Macro variables: Index files can be specified using
            macro variables.  Each filename, however, must be contained
            in a separate variable.  For example:

            ntx_1 = "Name"
            ntx_2 = "Account"
            SET INDEX TO &ntx_1., &ntx_2.

            Macro variables substituting a null string ("") or spaces
            are ignored.

Library:    CLIPPER.LIB