Difference between revisions of "System Menu"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
(20 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" | ||
− | !Option||Description||Notes | + | !Menu||Option||Description||Notes & Links |
+ | |- | ||
+ | |File|||||| | ||
+ | |- | ||
+ | |||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) |
|- | |- | ||
− | | | + | |||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|| |
|- | |- | ||
|} | |} | ||
− | |||
[[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 |