SQLGrid 3

 

  Release Notes

Known Isses

  • There is a problem using the Schema Browser with Personal Oracle.

Future

  • Add scripting support for constraints.
  • Add scripting support for indexes.
  • Add scripting support for triggers.
  • Please email requests for additional functionality

2.43.0

  • Added user name and service to title bar so you can tell what schema SQLGrid is connected to when SQLGrid in minimized to the taskbar.
  • Added more information when describing foreign key constraints about the foreign table and columns.
  • Added additional error handling in the schema browser.
  • Added Describe context menu to Triggers, Indexes, Constraints, Packages, Procedures and Functions in the Schema Browser.
  • Added Status, Description and When Clause to Trigger describe.
  • Added describe support for Packages, Package Bodies, Procedures and Functions.
  • Added schema owner support into describe parser.
  • Added Schema Browser options.
  • Added the ability to display describes on a new tab.
  • Added tip of the day dialog. Let me know if you have a suggestion for a good tip of the day.

2.42.0

  • Revised the Options dialog to allow for room for descriptions of options to make up for the lack on online help.

2.41.0

  • Added support Windows XP visual styles.

2.40.0

  • Added support for connecting to a database using NT authentication.
  • Added sequences to the schema browser.
  • Added describe sequence.
  • Added script sequence.

2.39.0

  • Added context menus to schema browser.

2.38.0

  • Added table analyzis tool to analyze tables and their indexes and compute statistics used by the Oracle optimizer to ensure that queries are executed in the most performant manor.

2.37.0

  • Revamped statistics engine to retrieve static keys from Oracle as it seems that these numbers change between Oracle versions.
  • Added new statistic picker dialog to minimize calls to Oracle.

2.36.0

  • Added toolbar buttons for options and statistics.

2.35.0

  • Added statistical functionality to allow a query to be analyzed. Collectable statistics include db block gets, physical reads, sorts, etc. All oracle statistics are available.
  • Added option to show query results.
  • Added option to show query execution plans.
  • Added option to show query execution statistics.

2.34.0

  • Added an edit command which opens the table or query into an editable grid and which can be used to edit, delete and add data.
  • Changed version numbering scheme to distinguish between enhancements and patches

2.0.33

  • Help for SQLGrid commands and Release Note are now displayed on their own tabs.
  • Release Notes are automatically displayed the first time a new version is opened.
  • Added Repair Database Objects utility into SQLGrid.
  • Fix expand package contents.

2.0.32

  • Removed grid from output panel. May add support for editable grid in a window if someone finds it useful.
  • Add ability to create and remove additional output tabs to allow switching between query outputs.
  • Added ability to rename output tabs.

2.0.31

  • Docked Schema Browser to work area.
  • Disables toolbar when not connected to a database.
  • Improved drag and drop editing with schema browser.
  • Changed context highlighting to occur when line changes rather than on type to reduce flicker.

2.0.30

  • Added execute SQL file using @. Currently this functionality is limited to 32K files.

2.0.29

  • Added context highlighting to editor.

2.0.28

  • Added SAVERAW and SAVEXML commands.
  • Added delete to login connection list.

2.0.27

  • Added constraints and triggers to enhanced table describe.
  • Added columns to constraint describe.
  • Fixed bug with large selections crashing.
  • Cleanup up SQL in progress display.

2.0.26

  • Fixed desktop flicker during typing.
  • Added commit and rollback buttons to the toolbar.
  • Removed syntax highlighting.
  • Optimized object type identification algorithm.
  • Added indexes to enhanced table describe.

2.0.25

  • Added syntax highlighting to SQL entry field.
  • Added drag and drop editing support to schema browser.
  • Added drag and drop editing support to scrapbook.
  • Added drag and drop editing support to history.
  • Added describe constraints.
  • Added commit and rollback feedback.
  • Enhanced index describe.
  • Enhanced status messaging during report formatting.
  • Fixed execute bug not handling more than one parameter.

2.0.24

  • Added schema browser tool with explore table and view functionality.

2.0.23

  • Add more information to status display during SQL executing.
  • Added progress bar to status bar.
  • Added list of previous connection to the login dialog box. When a previous connection is selected, the password is defaulted to the user name.
  • Fixed bug with script generation adding each column multiple times.
  • Fixed word wrap in describes.

2.0.22

  • Fixed error in parser not trimming spaces from object names.
  • Added connection information to status bar.
  • Added Release Notes command to Help menu.

2.0.28

  • Added SAVERAW and SAVEXML commands.
  • Added delete to login connection list.

2.0.27

  • Added constraints and triggers to enhanced table describe.
  • Added columns to constraint describe.
  • Fixed bug with large selections crashing.
  • Cleanup up SQL in progress display.

2.0.26

  • Fixed desktop flicker during typing.
  • Added commit and rollback buttons to the toolbar.
  • Removed syntax highlighting.
  • Optimized object type identification algorithm.
  • Added indexes to enhanced table describe.

2.0.25

  • Added syntax highlighting to SQL entry field.
  • Added drag and drop editing support to schema browser.
  • Added drag and drop editing support to scrapbook.
  • Added drag and drop editing support to history.
  • Added describe constraints.
  • Added commit and rollback feedback.
  • Enhanced index describe.
  • Enhanced status messaging during report formatting.
  • Fixed execute bug not handling more than one parameter.

2.0.24

  • Added schema browser tool with explore table and view functionality.

2.0.23

  • Add more information to status display during SQL executing.
  • Added progress bar to status bar.
  • Added list of previous connection to the login dialog box. When a previous connection is selected, the password is defaulted to the user name.
  • Fixed bug with script generation adding each column multiple times.
  • Fixed word wrap in describes.

2.0.22

  • Fixed error in parser not trimming spaces from object names.
  • Added connection information to status bar.
  • Added Release Notes command to Help menu.