[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
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()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson