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

 CLEAR SCOPE
 Clears current index SCOPE values
------------------------------------------------------------------------------

 Syntax

     CLEAR SCOPE

 Description

     CLEAR SCOPE clears the SCOPE values previously set with any SCOPE
     command or function. Both the TOP and BOTTOM values are cleared,
     and the subset view of the index is eliminated.

     Advantage SCOPE commands and functions allow you to view a subset
     of records in an index. Bottom and top index key limits may be defined
     to retrieve only those records that fit within the specified SCOPE
     range. The range acts as a temporary filter on an index, allowing
     rapid retrieval of only those records within the SCOPE range
     value(s). The range values are determined based on the current
     index.

     SCOPE values are set with SET SCOPE commands and functions. A TOP
     value and BOTTOM value are assigned to define the SCOPE range.
     The TOP and BOTTOM values may be the same value. Once the TOP
     and BOTTOM values are set, only those records within the range are
     visible.

     Advantage SCOPE commands are not to be confused with CA-Clipper
     <scopes>.  Advantage SCOPES are used to view a subset of table
     records based on an existing index; CA-Clipper <scopes> are
     used to build a new index based upon a subset of table
     records.

     Scopes exist per index order. That is, each index order in each work
     area can have its own scope. Only the scope on the currently active
     index order in the currently active work area is in effect, however.
     Scopes continue to exist until the scope is cleared (using
     CLEAR SCOPE) or the corresponding index is closed. Changing active
     index orders and/or work areas does not clear a scope; it just changes
     what scope is in effect.

 Example

     #include "DBFCDXAX.CH"

     USE test VIA "DBFCDXAX"
     INDEX ON state TAG state

     SET SCOPE TO "AZ"

     // Only those recods where state is Arizona should be visible
     Browse()

     CLEAR SCOPE