[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 SET INDEX
 Open one or more order bags in the current work area
------------------------------------------------------------------------------
 Syntax

     SET INDEX TO [<xcOrderBagName list>] [ADDITIVE]

 Arguments

     <cOrderBagName list> specifies order bags to be emptied into the
     order list of the current work area.

     ADDITIVE adds order bags to an existing order list.

 Description

     By default, SET INDEX, without the ADDITIVE clause, clears the currently
     active order list, and then constructs a new order list from the orders
     in the specified order bags in the current work area.  When several
     order bags are opened, the first order in the first order bag becomes
     the controlling order (has focus).  The record pointer is initially
     positioned at the first logical identity in this order.

     If an order list exists when you SET INDEX ... ADDITIVE, the orders in
     the new order bag are added to the end of the order list.  The previous
     controlling order continues to be the controlling order.

     If no order list exists when you SET INDEX ... ADDITIVE, the first order
     in the first order bag in <cOrderBagName list> becomes the controlling
     order.

     During database processing, all open orders are updated whenever a key
     value is appended or changed, unless the order was created using a
     scoping condition and the key value does not match.  To change the
     controlling order without issuing another SET INDEX command, use SET
     ORDER or ORDSETFOCUS().  To add orders without closing the currently
     open orders, use the ADDITIVE clause.

 Examples

     .  This example opens a database and its associated indexes:

        USE Sales NEW
        SET INDEX TO Sales, Sales1, Sales2

     .  This example opens an index without closing any indexes that
        are already open:

        SET INDEX TO Sales3 ADDITIVE


See Also: CLOSE DBCLEARIND() DBSETINDEX() INDEX REINDEX
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson