Use the Set menu to set filter, relation, exclusive, read-only mode for the existing database file.
|Set menu commands||Description|
|Set Filter On|| When a FILTER condition is SET, the current work area acts as if it contains only the records that match the specified condition. A filter condition is one of the properties of a work area.
|Set Filter Off|| Deactivates the filter condition.
|Set Scope On||Change the top and/or bottom boundaries for scoping key values in the controlling order.|
|Set Scope Off||Clears the top and bottom scope.|
|Set Relation||A database command that links a parent work area to one or more child work areas using a key expression, record number, or numeric expression. Each parent work area can be linked to child work areas. A relation causes the record pointer to move in the child work area in accordance with the movement of the record pointer in the parent work area.|
|Drop Relation||Deactivates the existing relation for the active table.|
|Show deleted records||Toggles automatic filtering of records marked for deletion in the current database file. When it is unchecked, most commands ignore deleted records. If, however, you refer to a record by record number (GOTO or any command that supports the RECORD scope), the record is not ignored even if marked for deletion.|
|Exact count|| When it is checked, the total count of records gives the logical count based on indexes, Set range, Filter, and Show deleted records.
Note: Carefully consider if you want to set the Exact count for large files. The delay for huge files may be considerable since every record must be scanned.
|Exclusive mode||When it is checked, the current database open in a nonshared (exclusive) mode. Use EXCLUSIVE only for operations that absolutely require EXCLUSIVE MODE of a database file, such as PACK, REINDEX, and ZAP.|
|Read-only mode||Opens database with a read-only attribute. This lets you open database files marked read-only. If you cannot open the database this way, a runtime error is generated. If this clause is not specified, database is opened as read-write.|
|Use ANSI characters||If checked use OEM characters(DOS) else use ANSI characters(Windows) for the current database file.|