Set menu

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.

Shortcut: ALT+F
Set Filter Off Deactivates the filter condition.

Shortcut: CTRL+ALT+N
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.