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

  CLEAR ORDER:

  Syntax:

  CLEAR ORDER <nOrder>

    <nOrder> indicates which index order to close.

  Allows you to selectively close a single index without closing any other
  open indexes.  Any indexes in a greater order position will be moved up
  one order position.

    NOTE:  If you clear the active order, order is set to zero (0).

    NOTE:  This command is NOT supported under SIXNTX.

  Example:

    #include "SIXCDX.CH"

    LOCAL nX := 0

    USE test VIA "SIXCDX"                          // Open Database
    SET INDEX TO last, state, age, zip             // Open four IDX files

    FOR nX := 1 TO Sx_IndexCount()                 // Loop thru index order
      ? AllTrim( Str( nX )) + " " + Sx_IndexName() //  displaying each one
    NEXT

    // 1 LAST.IDX
    // 2 STATE.IDX
    // 3 AGE.IDX
    // 4 ZIP.IDX

    CLEAR ORDER 2                                  // Close just STATE.IDX

    FOR nX := 1 TO Sx_IndexCount()                 // Loop thru index order
      ? AllTrim( Str( nX )) + " " + Sx_IndexName() //  displaying each one
    NEXT

    // 1 LAST.IDX
    // 2 AGE.IDX
    // 3 ZIP.IDX