Application menu

Saturday, 17 April 2010 19:25

Top menu

The top menu has this structure: File, Tools, Wizards, SQL Marks and Help.

File

The tools submenu is composed of following items:

• Clear/Load/Save SQL Console:
  This items clears/loads/saves the sql console pane, which is used to insert sql statements. After clearing the pane you can still view the executed sql queries in the SQL details pane


• Clear/Save SQL details:
  Allows you to clear or save the details of the executed sql statements.
• Clear Error console:
  
  The Error console is a pane where all sql or program based errors are displayed. The clear item will erase all the contents of the error console pane.
• Save results from table/query as...: This will save the content of the grid int the file. You can choose delimiter for fields, delimiter for string fields and add column names as first line in the file.

All save/load operations have encoding combos included.

Tools

Manage connection

For further details see connection configuration section.

Preferences

The preferences window allows you to change certain runtime variables. In the next versions many new subitems will be included, so this help will get extended. The preferences are written into the file client.properties. This file has a classical .ini format, so you can edit it using an ordinary text editor.

So far the editable variables are:

• SQL sort - for now it has to be set to true. It affects the behavior of the content of table pane upon right clicking on the column header. This will cycle through the sorting of the table (ascending/descending/none). The idea behind SQL or non SQL sort is, that in certain situation one would not want to perform another query to the sql server, but rather do an algorithmic sorting. Usually it is a better idea to do a SQL sort because of the memory consumption / cpu issues.
• Automatic refresh of content of table - if set to true, after executing an insert/update/delete the content of table tab get automatically refreshed.
• Execute sqlmark after load - the default behavior of sqlmark upon it's selection is only to get displayed in the SQL Console. If set to true, the sqlmark will not only get displayed but also executed.
• Default limit - the default limit used in select queries within the Content of table tab.
• Default table data tab - which tab will be shown after selecting table in the db tree.
• Prompt for password if missing - if there is no password stored for the connection, you will be prompted when trying to connect.
• Save cols settings after refresh - remembers show/hide column selection after refresh of Content of table.

SQL marks

The SQLMarks are a shortcuts for the most frequently used queries. You can create/edit/delete/move a sqlmark through this menu.

• Creating SQLMarks:
  You can create SQLMarks by selecting a query in the SQL Console pane,entering the SQLMarks menu and hitting add sqlmark item. This will open up an Add SQLmarks window where you have to name the sqlmark and choose a node within the sqlmarks tree. Another way to add sql is via menu item Manage SQLMarks.
• Editing/moving/deleting items and creating folders is possible via the item Manage SQLMarks.

The rest of the SQLMarks menu is composed of all the saved sqlmarks. The SQLMarks menu tree gets updated in a way that folders are submenus and sqlmarks are menu items within those folders.
After all actions are confirmed in the dialog Manage SQLMarks the new submenu is recreated.
The internals of the SQLMarks are stored in the sqlmarks.xml file. If you have a basic knowledge of xml you can make your changes directly, but any mistake will result in the SQLMark menu will be unusable.

Wizards

• Create table wizard - for further details see wizards section.

Help

The help submenu is composed of two items: Help contents and About.