User Tools

Site Tools



This shows you the differences between two versions of the page.

Link to this comparison view

setmenu [2016/04/15 09:20]
dbfmanager created
setmenu [2016/04/15 10:30] (current)
Line 1: Line 1:
 +====== 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. |
setmenu.txt ยท Last modified: 2016/04/15 10:30 by dbfmanager