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

  SET SCOPE:

  Syntax:

  SET SCOPE TO [<value>]

  <value> specifies the high/low boundary values to establish the range
  of visible records within the current index.  Both the high and
  low scope values are set to <value> using this command, giving you a
  tightly focused scope of records.

  The specified scope is active as soon as the record pointer is
  repositioned using GO TOP, GO BOTTOM or SEEK.  Using
  GOTO will allow the record pointer to be positioned outside the
  active scope.

  The specified scope is identified with the current index or tag and
  remains in effect until the scope is cleared (using CLEAR SCOPE or SET
  SCOPETOP TO and SET SCOPEBOTTOM TO) or the index is closed.

    NOTE: For those situations where SET SCOPE cannot be used, such as when
          a compound condition is needed, our Mach SIx query optimizer can
          optimize SET FILTER with nearly the speed of SET SCOPE.


    NOTE:  This command is NOT supported under SIXNTX.

  Example:

    #include "SIXCDX.CH"

    USE test VIA "SIXCDX        // Open TEST.DBF
    INDEX ON state TAG state    // Create an index on the STATE field
    SET SCOPE TO "AZ"           // Sets the SCOPE to "AZ"
    Browse()                    // Browse all records from Arizona
    CLEAR SCOPE                 // Clears the SCOPE


  NOTE:  See the SCOPE.PRG program for a more detailed, practical example.