System Menu
From Recital Documentation Wiki
Access the menu using the Home key or the / key. To disable the menu, set sysmenu off; clear.
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... | Recital overview | ||
Reference guide... | Recital online documentation | Browser and Internet connection required | |
Key assist... | Function key usage | ||
Recital on the web... | Recital web site | Browser and Internet connection required | |
Check for updates... | Software updates | Browser and Internet connection required | |
Support... | Support contact details | ||
About Recital | License information |