Command SET SCOPE Foundation
Sets/clears scope values for logical or physical orders
SET SCOPE TO
SET SCOPE TO <xValue>
SET SCOPE TO <xTop>, <xBottom>
SET SCOPETOP TO
SET SCOPETOP TO <xTop>
SET SCOPEBOTTOM TO
SET SCOPEBOTTOM TO <xBottom>
BScope:!EF current work area, current order
A scope is used to quickly specify a range of records in a database. Only those records whose scope values lie within the range of the top and bottom scope values are visible. In general, scoping can be used in any situation that would require a SEEK/WHILE loop. Scoping is particularly useful for browsing a database with TBrowse() or XbpBrowse(), since it is far simpler to use a scope than to set up a custom skip block, and is extremely fast. Also, scoping is good for query processing where scopes can be used to restrict the number of records and an additional filter is used to determine the relating subsets of the query.
A scope can be set for each order, be it a physical or logical order. A table may have its own scope using a record number as the scope value. The scope remains active until it is cleared using SET SCOPE TO (with no value) or the relating index or table is closed.
SET SCOPE TO with no parameters clears both the top and bottom scope.
SET SCOPETOP TO with no parameters clears the top scope.
SET SCOPEBOTTOM TO with no parameters clears the bottom scope.
SET SCOPE TO <xValue> sets both the top and bottom scope value for the controlling index to the same value.
SET SCOPE TO <xTop>, <xBottom> sets the top and bottom scope value for the controlling index to different values in a single command.
SET SCOPETOP TO <xTop> sets the top scope to the given value.
SET SCOPEBOTTOM TO <xBottom> sets the bottom scope to the given value.
Scoped database navigation
Positions the record pointer on the first record matching <xTop>.
Positions the record pointer on the last record matching <xBottom>.
Is set to .T. (true) when attempting to move the record pointer before <xTop>.
Is set to .T. (true) when attempting to move the record pointer behind <xBottom>.
Finds only records that lie within the scope.
Moves the record pointer to the specified record, which may be located outside of the scope. If the record pointer is outside the scope it will be positioned at Eof() with the next SKIP operation.
This function and DbGoPosition() are conforming with the scope settings, they return 0% for DbGoTop() and 100% for DbGoBottom(). Therefore they are restricted to positions inside the rowset as defined by the scope.
There is no restriction with SET RELATION TO ... SELECT either. Filters, scopes and relational restrictions can be defined simultaneously.
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.