Viva Clipper !

SET SCOPE

vivaclipper
Advertisements

SET SCOPE

Change the top and/or bottom boundaries for scoping key values in the controlling order

Syntax

      SET SCOPE TO [<expNewTop> [, <expNewBottom>]]

Arguments

<expNewTop> is the top range of key values that will be included in the controlling order’s current scope. <expNewTop> can be an expression that matches the data type of the key expression in the controlling order or a code block that returns the correct data type.

<expNewBottom> is the bottom range of key values that will be included in the controlling order’s current scope. <expNewBottom> can be an expression that matches the data type of the key expression in the controlling order or a code block that returns the correct data type.

Note

If <expNewBottom> is not specified, <expNewTop> is taken for both the top and bottom range values.

Description

SET SCOPE, when used with no arguments, clears the top and bottom scopes; this is equivalent to ORDSCOPE(0, NIL) followed by ORDSCOPE(1, NIL). If <expNewTop> is specified alone, SET SCOPE sets the top and bottom scope to the indicated value (i.e., ORDSCOPE(0, <expNewTop>) followed by ORDSCOPE(1, <expNewTop>). If both <expNewTop> and <expNewBottom> are specified, SET SCOPE sets the top and bottom scope as indicated (i.e., ORDSCOPE(0, <expNewTop>) followed by ORDSCOPE(1, <expNewBottom>). Refer to the ORDSCOPE() function for more information.

Examples

      .  The following example illustrates the SET SCOPE command:

         USE Inventor NEW
         INDEX ON PartNo TO Parts

         SET SCOPE TO 1750, 2000
         // Only part numbers between 1750 and 2000 will be used

Seealso

ORDSCOPE(), SET SCOPEBOTTOM, SET SCOPETOP

Advertisements

Advertisements