| Introduction, Features and Screen Shots For a more detailed description see the paper by Gerd Wagner and Glenn Griffin: English version German version The SQuirreL desktop in Ocean Theme Introduction: Configure or add a driver. Create an Alias. Features, Screen Shots Object Tree of Session window Right-click to access the popup menu which provides access to advanced script generation and graphing features. The graph plugin allows the user to create table charts. SQL Editor with code completion popup (ctrl+space) open Code completion can be used to access drop-down lists of options that include keywords, tables, columns, views, stored procedures. Code completion also provides join generation functions. For example, look at the table structure here. Hitting ctrl+space after the expression `#i,ITEM,PRODUCT,PRODUCT_DETAILS,` (note the comma at the end) SQuirreL will expand it to: `INNER JOIN PRODUCT ON PRODUCT.PRODUCTID = ITEM.PRODUCTID INNER JOIN PRODUCT_DETAILS ON PRODUCT.PRODUCTID = PRODUCT_DETAILS.PRODUCTID``` SQL Editor with tools popup menu (ctrl+t) shown With the tools popup any editor function can be located with only a single short cut: ctrl+t Additionally, the list can be searched incrementally with just a few keystrokes. SQL Editor with bookmark selection popup (ctrl+j) shown Bookmarks are user-defined code templates. SQuirreL comes with several pre-defined example bookmarks for the most common SQL and DDL statements. Abbreviations and auto corrections dialog This feature works much like auto corrects in common office products. With the entries shown in the dialog you may for example type 'sf<space>' which will expand to 'SELECT * FROM'. Editing of SQL results. The result tabs of SQL queries support editing the rows returned from a query on a single table. You may also edit the contents tab of tables in the Object tree. Graph: Charts of tables and their relations. To create new charts or to add tables to existing charts right mouse click tables in the Object tree and choose the 'Add to graph' menu. Graph manipulation functions can be accessed by using the right-click context popup menu. Graph: Scaling and distributing tables on configurable page sizes to prepare for printing Use the right-click context popup menu to switch to the scaling and printing mode. |