System Menu

From Recital Documentation Wiki
Jump to: navigation, search

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