Difference between revisions of "System Menu"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 99: | Line 99: | ||
|||Minimum value...||Calculate minimum value of anumeric field ||[[CALCULATE]] (prompts to open a table if no table is active) | |||Minimum value...||Calculate minimum value of anumeric field ||[[CALCULATE]] (prompts to open a table if no table is active) | ||
|- | |- | ||
| − | |||Standard deviation...||Calculate standard deviation for a numeric field||[[CALCULATE] (prompts to open a table if no table is active)] | + | |||Standard deviation...||Calculate standard deviation for a numeric field||[[CALCULATE]] (prompts to open a table if no table is active)] |
|- | |- | ||
|||Variance...||Calculate variance for a numeric field||[[CALCULATE]] (prompts to open a table if no table is active) | |||Variance...||Calculate variance for a numeric field||[[CALCULATE]] (prompts to open a table if no table is active) | ||
| Line 107: | Line 107: | ||
|Organize|||||| | |Organize|||||| | ||
|- | |- | ||
| − | |||Index...|||| | + | |||Index...||Build an index o the active table||[[INDEX]] (prompts to open a table if no table is active) |
|- | |- | ||
| − | |||Reindex all...|||| | + | |||Reindex all...||Rebuild the indexes of all open tables||[[REINDEX]] (prompts to open a table if no table is active) |
|- | |- | ||
| − | |||Append from...|||| | + | |||Append from...||Import records into the active table||[[APPEND FROM]] (prompts to open a table if no table is active) |
|- | |- | ||
| − | |||Copy to...|||| | + | |||Copy to...|||Exports records from the active table|[[COPY]] (prompts to open a table if no table is active) |
|- | |- | ||
| − | |||Total to...|||| | + | |||Total to...||Exports totals of the numeric fields in the active table||[[TOTAL]] (prompts to open a table if no table is active) |
|- | |- | ||
| − | |||Pack all...|||| | + | |||Pack all...||Permanently remove records marked for deletion from all open tables||[[PACK]] (prompts to open a table if no table is active) |
|- | |- | ||
| − | |||Zap...|||| | + | |||Zap...||Permanently remove all records from the active table||[[ZAP]] (prompts to open a table if no table is active) |
|- | |- | ||
|Help|||||| | |Help|||||| | ||
Revision as of 10:02, 2 March 2010
The following options are available from the System Menu:
| Menu | Option | Description | Notes & Links |
|---|---|---|---|
| File | |||
| New... | Create a new file | Types: Database, Table, View, Bridge, Connection, Program, Form, Report, Label, Text | |
| Open... | Open a file | Types: Database, Table, View, Bridge, Connection | |
| Close | Close open files | CLOSE DATABASES | |
| Exit | Exit Recital | QUIT | |
| Edit | |||
| Append | Add a new record to the active table | APPEND | |
| Browse | Browse the active table | BROWSE | |
| Edit | Edit the active table | EDIT | |
| Delete... | Delete one or more records in the active table | DELETE | |
| Recall... | Recall one or more deleted records in the active table | RECALL | |
| Find... | Browse the active table for records matching search criteria | SEEK (indexed) or LOCATE (unindexed) | |
| View | |||
| List tables | List tables in the current directory, path and database | LIST TABLES | |
| List structure | List structure of the active table | LIST STRUCTURE | |
| Print structure | Print structure of the active table | LIST STRUCTURE | |
| List status | List the session status | LIST STATUS | |
| Print status | Print the session status | LIST STATUS | |
| List dictionary | List the dictionary of the active table | LIST DICTIONARY | |
| Print dictionary | Print the dictionary of the active table | LIST DICTIONARY | |
| List memory | List current memory variables | LIST MEMORY | |
| Print memory | Print current memory variables | LIST MEMORY | |
| Tools | |||
| Table designer | Create a new table or modify an existing one | MODIFY STRUCTURE | |
| Form designer | Create a new screen form or modify an existing one | MODIFY SCREEN | |
| Report designer | Create a new report or modify an existing one | MODIFY REPORT | |
| Label designer | Create a new label or modify an existing one | MODIFY LABEL | |
| Calculator | Popup calculator | CALCULATOR | |
| Diary | Popup diary | CALENDAR | |
| Notepad | Popup notepad | TEXTEDIT() | |
| Program | |||
| Dir... | List program (.prg) files in the current directory and path | DIR | |
| Editor... | Edit a new or existing program file | VI | |
| Do... | Run a program | DO | |
| Debug... | Debug a program | DEBUG | |
| Compile... | Compile one or more programs | COMPILE | |
| Reports | |||
| Report Generator... | Run an existing report | REPORT (prompts to open a table if no table is active) | |
| Label Generator... | Run an existing label | LABEL (prompts to open a table if no table is active) | |
| QuickReport... | Generate an ad-hoc report | (prompts to open a table if no table is active) | |
| QuickLabels... | Generate an ad-hoc label | (prompts to open a table if no table is active) | |
| Summary | |||
| Sum... | Sum numeric field values | CALCULATE (prompts to open a table if no table is active) | |
| Average... | Average numeric field values | CALCULATE (prompts to open a table if no table is active) | |
| Count... | Perform a record count | CALCULATE (prompts to open a table if no table is active) | |
| Maximum value... | Calculate maximum value of a numeric field | CALCULATE (prompts to open a table if no table is active) | |
| Minimum value... | Calculate minimum value of anumeric field | CALCULATE (prompts to open a table if no table is active) | |
| Standard deviation... | Calculate standard deviation for a numeric field | CALCULATE (prompts to open a table if no table is active)] | |
| Variance... | Calculate variance for a numeric field | CALCULATE (prompts to open a table if no table is active) | |
| All of the above... | Perform all of the calculations above | CALCULATE (prompts to open a table if no table is active) | |
| Organize | |||
| Index... | Build an index o the active table | INDEX (prompts to open a table if no table is active) | |
| Reindex all... | Rebuild the indexes of all open tables | REINDEX (prompts to open a table if no table is active) | |
| Append from... | Import records into the active table | APPEND FROM (prompts to open a table if no table is active) | |
| Copy to... | Exports records from the active table|COPY (prompts to open a table if no table is active) | ||
| Total to... | Exports totals of the numeric fields in the active table | TOTAL (prompts to open a table if no table is active) | |
| Pack all... | Permanently remove records marked for deletion from all open tables | PACK (prompts to open a table if no table is active) | |
| Zap... | Permanently remove all records from the active table | ZAP (prompts to open a table if no table is active) | |
| Help | |||
| Help... | |||
| Reference guide... | |||
| Key assist... | |||
| Recital on the web... | |||
| Check for updates... | |||
| Support... | |||
| About Recital |
Access the menu using the Home key or the / key (not available when set pckeys is on). To disable the menu, set sysmenu off.
