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. |