Difference between revisions of "System Menu"

From Recital Documentation Wiki
Jump to: navigation, search
 
(19 intermediate revisions by one user not shown)
Line 1: Line 1:
 +
Access the menu using the '''Home''' key or the '''/''' key.  To disable the menu, [[SET SYSMENU|set sysmenu off]]; [[CLEAR|clear]].
 +
 
The following options are available from the System Menu:
 
The following options are available from the System Menu:
  
  
 
{| class="wikitable"
 
{| class="wikitable"
!Menu||Option||Description||Notes
+
!Menu||Option||Description||Notes & Links
 
|-
 
|-
 
|File||||||
 
|File||||||
 
|-
 
|-
|||New...||||
+
|||New...||Create a new file||Types: [[CREATE DATABASE|Database]], [[CREATE|Table]], [[CREATE VIEW|View]], [[CREATE BRIDGE|Bridge]], [[CREATE GATEWAY|Connection]], [[VI|Program]], [[CREATE SCREEN|Form]], [[CREATE REPORT|Report]], [[CREATE LABEL|Label]], [[VI|Text]]
 +
|-
 +
|||Open...||Open a file||Types: [[OPEN DATABASE|Database]], [[USE|Table]], [[SET VIEW|View]], [[USE|Bridge]], [[SQLCONNECT()|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 [[SET DEFAULT|directory]], [[SET PATH|path]] and [[DBF()|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 [[SET DEFAULT|directory]] and [[SET PATH|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)
 
|-
 
|-
|||Open...||||
+
|||Copy to...||Exports records from the active table||[[COPY]] (prompts to open a table if no table is active)
 
|-
 
|-
|||Close|||||
+
|||Total to...||Exports totals of the numeric fields in the active table||[[TOTAL]] (prompts to open a table if no table is active)
 
|-
 
|-
|||Exit||||
+
|||Pack all...||Permanently remove records marked for deletion from all open tables||[[PACK]] (prompts to open a table if no table is active)
 
|-
 
|-
|CURSOR UP||Skip to previous field
+
|||Zap...||Permanently remove all records from the active table||[[ZAP]] (prompts to open a table if no table is active)
 
|-
 
|-
|DELETE FIELD||Initialize field
+
|Help||||||
 
|-
 
|-
|EDIT FIELD||Enter field edit mode
+
|||Help...||Recital overview||
 
|-
 
|-
|EXIT/SAVE||Write current record then exit from the form
+
|||Reference guide...||Recital online documentation||Browser and Internet connection required
 
|-
 
|-
|HELP||Activate pop-up help
+
|||Key assist...||Function key usage||
 
|-
 
|-
|MENUBAR||Activate the APPEND menu bar
+
|||Recital on the web...||Recital web site||Browser and Internet connection required
 
|-
 
|-
|NEXT RECORD||Write record then skip to next record
+
|||Check for updates...||Software updates||Browser and Internet connection required
 
|-
 
|-
|REFRESH||Redraw the form
+
|||Support...||Support contact details||
 
|-
 
|-
|TAB||Toggle function key menu on and off
+
|||About Recital||License information||
 
|-
 
|-
 
|}
 
|}
  
Access the menu using the '''Home''' key or the '''/''' key (not available when [[SET PCKEYS|set pckeys is on]]).  To disable the menu, [[SET SYSMENU|set sysmenu off]].
 
  
 
[[Category:UI COmmands]]
 
[[Category:UI COmmands]]

Latest revision as of 10:53, 7 September 2010

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