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 Files Library is CLIPPER.LIB.
See Also: ORDSCOPE()
Pingback: C5 Commands | Viva Clipper !