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

 set order to        Set the master index alias
------------------------------------------------------------------------------
 Syntax
   [!sAlias] set order to uOrder|sIndexAlias

 Arguments
   sAlias is the database to operate on.

   uOrder is the order number of the controlling index.

   sIndexalias is an index alias to set as the master index.

 Description
   The set order to command determines the master index alias associated
   with the current or specified database alias.

   uOrder has a range of 0 to 7. The default value is 0. set order to
   has no effect when used before a set index to, use...index or
   open...index command is executed because these commands reinitialize the
   order value to 0. The master index alias controls the record order of the
   current database.

 Example
   #define EXAMPLE_DATABASE
   #include example.hdr

   proc Test_setorderto
   open sTest index sIdxLN, sIdxB // index numbers are determined here
   ? indorder()              // the controlling index is sIdxLN
   set order to 2            // set the controlling index to be sIdxB
   ? indorder()              // prints 2
   set order to sIdxLN       // switch on sIdxLN again
   ? indorder()              // prints 1
   set order to              // turn off index
   ? indorder()              // prints 0
   endproc

   proc main
   Test_setorderto()
   endproc