Application menu

Last Updated on Sunday, 11 March 2012 17:03

Top menu

The top menu has this structure: File, Tools, Wizards, SQL marks and About.

File

The tools submenu is composed of following items:

• Save/Load/Clear SQL Console:
  This items saves/loads/clears 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 log 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:

General

• 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.
• 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.

View

• Look & Feel - JavaSwing's architecture enables multiple Look and Feels. The change is applicable after restarting myjgui application.
• Default table data tab - which tab will be shown after selecting table in the db tree.
• Show grid in tables, use different color for every other row - are setting the attributes of table view pane. Some look and feels may not support each such feature.
• Sql console font size - font size in Sql console.

Logs

• You can decide, what you want to log - query time, timestamp, count of processed rows for Log and Sql log panes.
• Font size - font size in log pane.

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 database wizard
• Create table wizard

(for further details see wizards section)

About

The about  submenu contains just one item: About.