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

  SUBINDEX:

  This command syntax is primarily the same as that for INDEX ON, behaving
  as if you've used the the SUBINDEX keyword.  This command will use an
  existing SCOPE / FILTER condition or index order when creating a new index.

    NOTE:  In prior releases of the SIx Driver, a FILTER condition was
           respected when creating a new index.  This behavior can now
           only be achieved if you use the FILTERON keyword.

  Examples:

     USE TEST VIA "SIXCDX"            // Open DBF
     SET INDEX TO STATE               // Select Index (IDX)
     SET SCOPE TO "CA"                // Look at just "CA"
     SUBINDEX ON test->LAST TO temp   // Create subindex

   Or:

     USE TEST VIA "SIXCDX"                     // Open DBF
     SET FILTER TO STATE == "CA"               // Look at just "CA"
     SUBINDEX ON test->LAST TO temp FILTERON   // Create subindex


  CAUTION: Do NOT attempt to create a new index or tag of the same name
  as the current index or tag.  For example, this must never happen:

     USE datafile
     SET INDEX TO myindex
     SUBINDEX ON field1 TO myindex