#
# this is tip of the day file for the Hironico Db Tool. 
# each line that begins with the # sign is a comment and is not interpreted.
# one line per tip: it will be reformatted properly at runtime.
# line format: tip title | tip text
#
### configuration tips
#
Look and Feel|You can change the look and feel of the application in the preferences dialog.
Extend the Db Tool|You can use any JDBC driver with db tool. Specify the JAR file in the connection dialog, the driver class will be autodetected.
Driver URL|When configuring a connection, if you know the JDBC URL, you can enter it directly without specifying any additional properties.
#
### visual db tips
#
Visual Db|Use the Visual DB feature to display the table relationships in a database, save it as a picture to embbed in your technical documents.
Navigate the Visual DB|The '+' sign on the top right corner of the Visual DB window lets you navigate easily in large diagrams.
Zoom the Visual DB|Hold on the Ctrl key and use the mouse wheel to zoom in and out while displaying a Visual DB diagram.
#
### sql editor tips
#
SQL autocomplete|Hit Alt-Space in the SQL editor to auto-complete the table names while typing your query.
Often used queries|Right click the SQL editor to quick load previously saved queries that you use often.
Execute SQL shortcut|While in the SQL editor, hit Alt-e to execute the query.
New SQL tab shortcut|While in the SQL editor, hit Ctrl-t to open a new SQL editor tab.
#
### SQL results tips
#
Export options|Right click the query results to show export options.
Excel export|Results can be exported in XLS format.