Difference between revisions of "System Menu"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 79: | Line 79: | ||
|Reports|||||| | |Reports|||||| | ||
|- | |- | ||
| − | |||Report Generator...||Run an existing report||[[REPORT]] | + | |||Report Generator...||Run an existing report||[[REPORT]] (prompts to open a table if no table is active) |
|- | |- | ||
| − | |||Label Generator...||Run an existing label||[[LABEL]] | + | |||Label Generator...||Run an existing label||[[LABEL]] (prompts to open a table if no table is active) |
|- | |- | ||
| − | |||QuickReport...||Generate an ad-hoc report|| | + | |||QuickReport...||Generate an ad-hoc report||(prompts to open a table if no table is active) |
|- | |- | ||
| − | |||QuickLabels...||Generate an ad-hoc label|| | + | |||QuickLabels...||Generate an ad-hoc label||(prompts to open a table if no table is active) |
|- | |- | ||
|Summary|||||| | |Summary|||||| | ||
|- | |- | ||
| − | |||Sum...||Sum numeric field values||[[CALCULATE]] | + | |||Sum...||Sum numeric field values||[[CALCULATE]] (prompts to open a table if no table is active) |
|- | |- | ||
| − | |||Average...||Average numeric field values||[[CALCULATE]] | + | |||Average...||Average numeric field values||[[CALCULATE]] (prompts to open a table if no table is active) |
|- | |- | ||
| − | |||Count...||Perform a record count||[[CALCULATE]] | + | |||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]] | + | |||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]] | + | |||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]] | + | |||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]] | + | |||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]] | + | |||All of the above...||Perform all of the calculations above||[[CALCULATE]] (prompts to open a table if no table is active) |
|- | |- | ||
|Organize|||||| | |Organize|||||| | ||
Revision as of 09:56, 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... | |||
| Reindex all... | |||
| Append from... | |||
| Copy to... | |||
| Total to... | |||
| Pack all... | |||
| Zap... | |||
| 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.
