Visual Database Explorer 2018.2 Major Update

A major new release of Visual Database Explorer is now available. This release features a restyling of the user interface to that of a more modern IDE and includes multiple feature enhancements and bug fixes. In this post, we’ll explore the two more significant enhancements,  but first a quick list of the release’s contents:

Enhancements:

  • Restyled the user interface using Windows’ Metro Light theme
  • Enhanced the SQL Editor’s case correction functionality
    • Added the ability to specify the case-correction style. Choices include Uppercase (default), lowercase, and title case
    • The current case correction style is now applied when a SQL document is first opened
    • Added the option to disable case correction
  • Updated the functionality that allowed for running a portion of a SQL document. The new functionality provides a specific command to “run selection”. The command is available from the Query menu, Query toolbar, Editor toolbar, and the editor’s context menu
  • Updated the Browse table functionality to control the timing of the execution and the style of SQL generated
    • Added the option to generate a query that lists each field rather than a “SELECT *”
    • Added the option to defer execution of a generated query. This allows the user to modify the generated SQL prior to execution
  • Added the ability to right-click on a SQL Editor tab and add the query to the SQL Favorites
  • Updated Favorites to save the order of the items when the application shuts down
  • Updated the application help to include the new enhancements and made several typographical error corrections

Bug Fixes:

  • Fixed an error that caused the application to shut down when requesting the Connect to Database dialog. This issue was specific to Windows 10 version 1803 (April 2018 Update).
  • Fixed an issue that prevented the Options Restore functionality from succeeding

Case Correction

With this update, you now have control over whether and how SQL keywords are case corrected in the SQL Editor.  We added two new options in the Option dialog’s Editor/General category that control the feature’s behavior.   The first option, “Enable auto case-correction”  let’s you turn the feature on and off.  It’s on (checked) by default.  The second option “Case correction style” controls the style of correction applied to keywords when the feature is enable.  You have the choice between uppercase, lowercase, and title case.  Uppercase is the default.  Finally, when case correction is turned on, Visual Database Explorer will now apply the configured case correction style to an existing SQL document when it is opened. As noted in the application help, changing case correction options does not take place until the next time Visual Database Explorer is started.

CaseCorrectionOptions
Case Correction Options

Browsing Contents

This update comes as a result of customer requests.  Visual Database Explorer has always included the ability to browse the contents of a queryable object such as a table or view.  You would just right-click on the object in the Connection Manager and select Browse.  That would open an new SQL Editor and immediately execute a SELECT * query against that object.  Now you can control the style and timing of a Browse contents query.

BrowseConfigOptions
Browse SQL Configuration Options

In the Environment/General section of the Options dialog, there’s a new section, Browse SQL Configuration, with the two options that control the updated feature.  The first option, “Generate with column names”, when checked directs the application to generate a SQL query that lists every column in the object, rather than a “SELECT *”.  Each column is listed on a separate line in the editor, making customization of the query very easy.  The second option “Immediately execute query” determines when the generated query is executed.  When checked, Visual Database Explorer sends the generated query to the server for execution immediately.  The default for these two options maintains the legacy behavior of the application.

Learn more about Visual Database Explorer by visiting our website.  Haven’t tried SOQL Studio yet?  Start your 30-day free trial today! And remember, customers with an active maintenance contract are entitled to this version free of charge.