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

  SET SCOPETOP:
  SET SCOPEBOTTOM:

  Syntax:

  SET SCOPETOP TO    [<value>]
  SET SCOPEBOTTOM TO [<value>]

  <value> specifies the high/low boundary values to establish the range
  of available keys within the current index.  This allows you to set a
  scope smaller than the current index without creating another
  conditional index file.

  Use SET SCOPETOP to set the starting key value (inclusive), and SET
  SCOPEBOTTOM to set the ending key value (inclusive).  SCOPETOP and
  SCOPEBOTTOM are designed to emulate the actual TOP and BOTTOM of the
  current index.  This means that descending indexes will have a higher
  SCOPETOP value than SCOPEBOTTOM value.

  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 age TAG age        // Create an index on the AGE field
    SET SCOPETOP TO 21          // Sets the top SCOPE value to 21
    SET SCOPEBOTTOM TO 30       // Sets the bottom SCOPE value to 30
    Browse()                    // Browse all records with ages from 21-30
    CLEAR SCOPE                 // Clears the SCOPE


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