Isidian Technologies, Inc. Home Products Downloads Support Company Shop   

 
  Isidian® SQL Insight
   · Standard
   · Professional
   · Features
   · Plugins
  Database Development
  Performance Tuning
  Documents
  Success Stories
  Comments
  Revision History
  System Requirements
  Request Information
  FAQ's

  Download Now
   · Extend Evaluation
   · Registration
  Buy Now
 
SQL Insight 2.0 Revision History


Enhancements / Corrected Defects
SQL EditorChanged Describe Object shortcut from Shift+F2 to F11
SQL EditorChanged Compare Bookmarks shortcut from Shift+F4 to Shift+F12
Completion ProposalNon-alphanumeric characters will close proposal
Completion ProposalObject lising is displayed if a valid owner is located before period
Completion ProposalMethod lising is displayed if a valid package or type is located before period
Completion ProposalForced max width of 400 pixels
Completion ProposalMouse hint used for text longer than max width
SQL EditorCreated hint class with ability to bold all or some of the output
SQL EditorDisplay hint for defined function parameters
SQL EditorDisplay hint for method parameters on database object (procedures, functions, type methods, etc.)
SQL EditorMultiple File support / multiple tab interface
SQL EditorRemoved current file name from SQL Editor window's caption
SQL EditorChanged shortcut on "Toggle Editor Focus" from Ctrl+Shift+Tab to Shift+Tab
SQL EditorAdded tab navigation (Ctrl+Tab - forward, Ctrl+Shift+Tab - backward)
SQL EditorChanged "Query" main menu item to "Run"
SQL EditorAdded shortcut to "New" File menu item (Ctrl+N)
SQL EditorAdded "Close" File menu item (Ctrl+F4)
SQL EditorAdded "Toggle Breakpoint" Run menu item (F5)
SQL EditorAdded "Debug Windows" menu item to Window menu
SQL EditorAdded "Breakpoints" to Debug Windows sub-menu
SQL EditorAdded "Call Stack" to Debug Windows sub-menu
SQL EditorAdded "Variables" to Debug Windows sub-menu
SQL EditorAdded "Enabled" to right-click menu when breakpoint under cursor
SQL EditorAdded "Breakpoint Properties" to right-click menu when breakpoint under cursor
SQL EditorAdded "Evaluate / Modify" Run menu item (Ctrl+F7)
SQL EditorAdded "Step Over" Run menu item (F8)
SQL EditorAdded "Step Into" Run menu item (F7)
SQL EditorAdded "Step Out" Run menu item (Shift+F8)
SQL Editor"New" will open a new tab instead of clearing contents (if needed)
SQL Editor"Open" will open file in a new tab
SQL EditorAdded "Close" to right-click menu (Ctrl+F4)
SQL EditorMultiple files may be dropped into editor from explorer (instead of just 1)
SQL EditorCompletion Proposal will show hourglass when necessary
SGA BrowserAdd statement to editor will open into new file tab
SQL BuilderAdd statement to editor will open into new file tab
SQL EditorCheck for debug access on login
SQL EditorAdded ability to execute PL/SQL scripts directly into debug mode
SQL EditorAllowed breakpoint color line
SQL EditorAllowed debug step line color line
SQL EditorAdded step line execution gutter marker
SQL EditorAdded breakpoint gutter marker
SQL EditorAdded breakpoint / step gutter marker
SQL EditorAdded exception encountered gutter marker
SQL EditorAdded disabled breakpoint gutter marker
SQL EditorAllowed gutter clicking for breakpoint toggling
SQL EditorHint breakpoint properties when cursor over breakpoint gutter marker
SQL EditorStatement execution will continue debug if debugging
SQL EditorCancel Statement will abort debug if debugging
SQL EditorExecuted statements or debug processes will cancel when application closed
SQL EditorDebug Variables will display value in hint when cursor over variable
Breakpoint PropertiesAdded breakpoint properties functionality
Breakpoint ListAdded list of all breakpoints with properties
Breakpoint ListAdded ability to locate source line via Dbl-Click or "View Source" menu item
Breakpoint ListAdded link to Breakpoint Properties via "Properties" menu item
Breakpoint ListAdded Stay on Top ability
Call StackAdded call stack functionality
Call StackAdded ability to locate source line via Dbl-Click or "View Source" menu item
Call StackAdded Stay on Top ability
VariablesAdded debug variables functionality
VariablesAdded link to Evaluate / Modify via Dbl-Click or "Modify" menu item
VariablesAdded Stay on Top ability
Evaluate / ModifyAdded ability to view and modify debug variables during debug execution
Evaluate / ModifyAdded Stay on Top ability
Statement SelectionAdded prompt for "Current Statement" or "All as Statement" when originally stepping into a PL/SQL block
SQL EditorAdded "New" menu item to Database menu
SQL EditorAdded "Function" to New sub-menu
SQL EditorAdded "Package" to New sub-menu
SQL EditorAdded "Procedure" to New sub-menu
SQL EditorAdded "Sequence" to New sub-menu
SQL EditorAdded "Table" to New sub-menu
SQL EditorAdded "Trigger" to New sub-menu
SQL EditorAdded "Type" to New sub-menu
SQL EditorAdded "View" to New sub-menu
SQL EditorAdded "Directories" menu item to Database menu
SQL EditorAdded "Parameters" menu item to Database menu
Database DirectoriesAdded Directories View
Database DirectoriesAdded ability to add directories
Database DirectoriesAdded ability to remove directories
Oracle ParametersAdded Parameters View
New FunctionAdded New Function Wizard
New PackageAdded New Package Wizard
New ProcedureAdded New Procedure Wizard
New SequenceAdded New Sequence Wizard
New TableAdded New Table Wizard
New TriggerAdded New Trigger Wizard
New TypeAdded New Type Wizard
New ViewAdded New View Wizard
Database BrowserAdded "New…" menu item to right-click menu
Database BrowserInvoke New Function from "New…" when functions selected
Database BrowserInvoke New Package from "New…" when packages selected
Database BrowserInvoke New Procedure from "New…" when procedures selected
Database BrowserInvoke New Sequence from "New…" when sequences selected
Database BrowserInvoke New Table from "New…" when tables selected
Database BrowserInvoke New Trigger from "New…" when triggers selected
Database BrowserInvoke New Type from "New…" when types selected
Database BrowserInvoke New View from "New…" when views selected
Describe TableAdded "Create Index…" menu item to Columns right-click menu
New IndexAdded New Index Wizard
Find in FilesRemoved modal window status
Find in FilesDouble-click loads file into editor instead of floating pane
Find in DatabaseRemoved modal window status
SQL Script ViewerReengineer parsing methods (allowing for more complex statements)
Parameters EntrySelect Value text on arrow key navigation
Parameters EntryAdded right-click menu to parameter listing
Parameters EntryAdded 'Show Usage' capability for multiple statement execution
Parameters EntryInvoke statement viewer to display statement executions for 'Show Usage'
SQL BuilderAdded Navigator ability
SQL BuilderRelocate positioning based on selection in Navigator
Add VariableAllow for drop-down selection of common functions
Add VariableHighlight function parameters on function selection
Add VariableAdded "Quote Variable (string)" checkbox
SQL BuilderHandle quoted variables as string variables
SQL EditorAllow statement executions with ending semi-colon
SQL EditorAdded Auto Completion Hints
SQL EditorAllowed Shift+Space to invoke Auto Completion from displayed hint
Export DataAdded "Export as Script" radio button
Export DataAdded "Export to delimited file" radio button
Export DataDisable "Export as Script" on read-only data set
Export DataMoved "Tab Delimited" to "Export to delimited file" sub-group
Export DataMoved "Comma Delimited" to "Export to delimited file" sub-group
Export DataMoved "Other" to "Export to delimited file" sub-group
Export DataMoved "Include Column Headers" to "Export to delimited file" sub-group
Export DataMoved "Double Quote Text" to "Export to delimited file" sub-group
Export DataExport data set as Insert scripts when "Export as Script" selected
Auto Completion OptionsRemoved "Add" button
Auto Completion OptionsRemoved "Modify" button
Auto Completion OptionsRemoved "Delete" button
Auto Completion OptionsAdded "Add" tool button
Auto Completion OptionsAdded "Modify" tool button
Auto Completion OptionsAdded "Delete" tool button
Auto Completion OptionsInvoke "Add" with Insert key on listing
Auto Completion OptionsInvoke "Delete" with Delete key on listing
Auto Completion OptionsInvoke "Modify" with Double-Click on listing
Editor OptionsRemoved Proposal Delay option (moved to Advanced Editor Options)
OptionsAdded "Advanced" tree item to options selection
OptionsAdded Advanced Editor Options functionality
Advanced Editor OptionsAdded Coding Aids group
Advanced Editor OptionsAdded Debugging group
Advanced Editor OptionsAdded option for Method Argument Hints
Advanced Editor OptionsAdded option for Auto Completion Hints
Advanced Editor OptionsAdded option for Automatic Completion Proposal
Advanced Editor OptionsAdded delay slider for Automatic Completion Proposal
Advanced Editor OptionsAdded option for Integrated Debugging
Advanced Editor OptionsAdded option to Stop on Exceptions
Completion ProposalScroll bar did not always update list position
SQL EditorDDL and PL/SQL run in background would not display appropriate errors
Database ConnectionArrow key navigation through previous connections will now update edit fields
Database BrowserPartition Information for tables would become invisible after navigation
Auto Completion OptionsDeleting an item would throw the list and source out of sync

SQL Insight 1.5 Revision History


Enhancements / Corrected Defects
SQL EditorChanged Explain Plan keyboard shortcut from F8 to Shift+F4
SQL EditorChanged Explain Plan All keyboard shortcut from Ctrl+F8 to Ctrl+Shift+F4
SQL EditorChanged Describe Object shortcut from F7 to Shift+F2
SQL EditorAdded menu images to right-click menu
Search DialogRemoved "Search from caret" checkbox
Search DialogRemoved "Selected text only" checkbox
Search DialogAdded "Scope" option box (replacing Selected text only)
Search DialogAdded "Origin" option box (replacing Search from caret)
Search DialogAdded "Regular Expressions" checkbox
Search DialogAdded regular expression functionality for both search and replace
Find in FilesAdded menu item to Search menu
Find in FilesAdded Find in Files dialog and functionality
Find in FilesLoad Statement Viewer on file double click
Find in DatabaseAdded menu item to Search menu
Find in DatabaseAdded menu item to Database Browser pop-up menu
Find in DatabaseAdded Find in Database dialog and functionality
Find in DatabaseLoad Describe window on object double click
Syntax HighlightingAdded customizable keyword functionality to the SQL highlighter
Syntax HighlightingAdded Java highlighter
Syntax HighlightingAdded C++ highlighter
Syntax HighlightingAdded HTML highlighter
Syntax HighlightingAdded Perl highlighter
Syntax HighlightingAdded XML highlighter
Syntax HighlightingAdded custom highlighter functionality
Syntax HighlightingAttached file filter to a specific highlighter
Highlighter OptionsRemoved preview pane
Highlighter OptionsAdded "Preview changes" checkbox
Highlighter OptionsAdded "Highlighter" drop-down selection
Highlighter OptionsAdded "Properties" button
Highlighter OptionsAdded "Delete" button
Highlighter OptionsAdded "Keyword Dictionary" button
Highlighter OptionsMinor window redesign
Highlighter OptionsAdded Highlighter Properties window
Highlighter OptionsAdded Keyword List window
Highlighter OptionsAdded "Keywords" registry key
SQL EditorAdded support for multiple highlighters
SQL EditorAdded "Syntax Highlighter" menu item (submenu toggles current highlighter) in right-click menu
SQL EditorAdded "Syntax Highlighter" tool button (for highlighter switching and options)
SQL EditorCompile "Open" dialog filter from highlighter filters
SQL EditorCompile "Save" dialog filter from highlighter filters
SQL EditorSave current highlighter name to registry when closing
SQL EditorLoad last used highlighter from registry when loading
SQL EditorLoad appropriate highlighter when file opened
SQL EditorChanged caption of Open dialog to "Open File"
SQL EditorChanged caption of Save dialog to "Save File"
Statement ViewerAdded support for multiple highlighters
Statement ViewerAdded right-click popup menu
Statement ViewerAdded "Syntax Highlighter" menu item (submenu toggles current highlighter) in right-click menu
Statement ViewerAdded "Save As" menu item in right-click menu
Statement ViewerCompile "Save" dialog filter from highlighter filters
Statement ViewerAdded "Undo" menu item in right-click menu
Statement ViewerAdded "Cut" menu item in right-click menu
Statement ViewerAdded "Copy" menu item in right-click menu
Statement ViewerAdded "Paste" menu item in right-click menu
Statement ViewerAdded "Select All" menu item in right-click menu
Statement ViewerAdded "Upper Case" menu item in right-click menu
Statement ViewerAdded "Lower Case" menu item in right-click menu
Statement ViewerAdded "Indent" menu item in right-click menu
Statement ViewerAdded "Unindent" menu item in right-click menu
Statement ViewerAdded "Describe Object" menu item (function as SQL Editor) in right-click menu
Auto Completion OptionsRemoved generic editor, replaced with Statement Viewer
Describe FunctionRenamed "Source" Tab to "DDL Script" Tab
Describe FunctionAdded "Create or Replace" to listed source
Describe PackageRenamed "Source" Tab to "DDL Script" Tab
Describe PackageRemoved Body Source Tab
Describe PackageAppended Package Body Script Tab to DDL Script
Describe PackageAdded "Create or Replace" to listed source
Describe PackageAdded "Create or Replace" to listed body source
Describe ProcedureRenamed "Source" Tab to "DDL Script" Tab
Describe ProcedureAdded "Create or Replace" to listed source
Describe SequenceAdded "DDL Script" Tab
Describe SequenceAdded Sequence DDL Reverse Engineering (script on DDL Script tab)
Describe TableAdded "DDL Script" Tab
Describe TableAdded Table DDL Reverse Engineering (script on DDL Script tab)
Describe TriggerRenamed "Source" Tab to "DDL Script" Tab
Describe TriggerAdded "Create or Replace" to listed source
Describe TriggerAdded Trigger DDL Reverse Engineering (script on DDL Script tab)
Describe TypeRenamed "Source" Tab to "DDL Script" Tab
Describe TypeRemoved Body Source Tab
Describe TypeAppended Package Body Script Tab to DDL Script
Describe TypeAdded "Create or Replace" to listed source
Describe TypeAdded "Create or Replace" to listed body source
Describe ViewRenamed "Source" Tab to "DDL Script" Tab
Describe ViewAdded "Create or Replace" to listed source
Describe ViewAdded View DDL Reverse Engineering (script on DDL Script tab)
Database BrowserAdded "Generate Schema Script" menu item
Database BrowserCreated progress bar for schema script generation
OptionsAdded DDL Script to Options Tree
DDL Script OptionsAdded to / not to include miscellaneous scripts while generating
Parameters EntryForced up and down arrow keys to change parameter on Parameter edit box
Parameters EntryForced up and down arrow keys to change parameter on Value edit box
Comparison OptionsAdded entry to calculate average based on X executions
Compare StatementsAdded ability to calculate averages based on preset number of executions
SQL EditorAdded "Compare Editor Contents" menu item to File Menu
SQL EditorAdded "Against Saved File" sub-menu item
SQL EditorAdded "Against File..." sub-menu item
Compare TextAdded text comparison functionality
Compare TextAdded text merge capabilities
Describe WindowAdded "Compare DDL Script" menu item to arrow menu
Describe WindowAdded "Against Editor Contents" sub-menu item
Describe WindowAdded "Against File..." sub-menu item
Describe WindowAdded "Against another Object" sub-menu item
Select Object WindowCreated and added to Describe - compare against another object
Database BrowserAdded "Compare Schema Script" menu item to pop-up menu
Database BrowserAdded "Against File..." sub-menu item
Database BrowserAdded "Against another Schema..." sub-menu item
Select Object WindowAllowed selection of only schema for schema ddl compare
SQL EditorAdded "New Instance" menu item to the File Menu
SQL EditorAdded "Source Code Control" menu item to the Tools Menu
SQL EditorAdded "SCC Manager" submenu item to the Source Code Control menu
SQL EditorAdded "Add to Provider" submenu item to the Source Code Control menu
SQL EditorAdded "Get Latest" submenu item to the Source Code Control menu
SQL EditorAdded "Check In File" submenu item to the Source Code Control menu
SQL EditorAdded "Check Out File" submenu item to the Source Code Control menu
SQL EditorAdded "Undo Check Out" submenu item to the Source Code Control menu
SQL EditorAdded "File Differences" submenu item to the Source Code Control menu
SQL EditorAdded "SCC Manager" button to Tools toolbar
SQL EditorAdded "Add to Provider" button to Tools toolbar
SQL EditorAdded "Get Latest" button to Tools toolbar
SQL EditorAdded "Check In File" button to Tools toolbar
SQL EditorAdded "Check Out File" button to Tools toolbar
SQL EditorAdded "Undo Check Out" button to Tools toolbar
SQL EditorAdded "File Differences" button to Tools toolbar
SQL EditorAdded check for file being checked out when loaded into editor
SCC ManagerAdded SCC Integration Capabilities
SCC ProviderAdded SCC Provider / Project selection Capabilities
SQL EditorAdded ability to login to SCC provider (project selection) on application start
SQL EditorAdded quick re-connect capabilities to reconnect to a database
SQL EditorChanged "Connect to Database" button to have drop-down
SQL EditorLoad last 5 connections into "Connect to Database" button drop-down
Password EntryAdded Password Entry window for reconnect (if password not stored)
SQL EditorAdded "FTP Manager" menu item to the Tools menu
SQL EditorAdded "FTP Manager" button to the Tools toolbar
FTP ManagerAdded full FTP client capabilities
RegistrationAllowed for evaluation extension
About BoxComplete redesign of interface
Splash ScreenComplete redesign of interface
DescribeRemoved size parameter from LOB columns
DescribeArguments in Oracle 9i for Procedures and Functions will now show
SQL EditorKeystroke shortcut modifications now update toolbar shortcuts
SQL EditorRead-only files are now being flagged read-only when opened
Search Dialog"Search for" hotkey will focus appropriate control
Replace Dialog"Search for" hotkey will focus appropriate control
Replace Dialog"Replace with" hotkey will focus appropriate control
History / Pin ListCorrected Access Violation when closing a sorted list
SQL EditorAuto-complete caused "List Index out of Bounds" when functions.acm was missing
DescribeCorrected auto-size of column name on Columns tab
Query ResultsCorrected "Index out of bounds" when multiple columns are grouped

SQL Insight 1.3 Revision History


Enhancements / Corrected Defects
Analyze TableWhen complete, the duration is displayed in seconds with the completion dialog.
ComparisonsComparisons may be performed from the SQL Editor by comparing statements at bookmarks.
Connect To DatabaseAdded ability to delete previous connections from the list by pressing delete while selecting the desired connection.
Connect To DatabasePasswords may be saved if selected to do so in the Miscellaneous Options.
Connect To DatabaseEncrypted previous connection file. Previous connection files may still be read and will be converted when saved.
Database BrowserAdded ability to analyze all tables when right-clicking the "Tables" branch.
DescribeAdded Partitions tab for partitioned tables.
DescribeAdded default column for the columns tab to display the column default.
DescribeAdded ability to view nested tables properties
DescribeAdded ability to view type collection properties
Explain PlanHinted labeled text on the information pane to prevent clipping.
Explain PlanAdded partition start and stop information, visible only when available.
Explain PlanAdded export options (Save to Image, Copy to Clipboard, and Print).
Explain PlanRemoved need for additional session to be connected.
Explain PlanTable name customization for the PLAN_TABLE found in the Miscellaneous Options.
FormattingAdded location for the formatting configuration file in the Formatting Options.
FormattingIf the formatting configuration file is read-only, changes may not be made to the formatting settings.
GridSummations created on the Summary Footer are now affected by any selected filter.
GridThe contents of the grid may also be saved to XML and Text in addition to XLS and HTML.
History ListAdded application synchronization, allowing all open instances of SQL Insight to share a common History List.
List ViewsAll list views within the application may be sorted, both ascending and descending, by clicking on the column header in which to sort.
OptionsAdded application synchronization, allowing all open instances of SQL Insight to be affected by the changes made in options.
Pin ListAdded application synchronization, allowing all open instances of SQL Insight to share a common Pin List.
SGA BrowserAdded Explain Plan tab to view Explain Plan results on the selected statement.
SGA BrowserAdded Statistics tab to view the selected statements statistics compared to the average.
SQL BuilderAdded Explain Plan tab to view Explain Plan results on the generated statement.
SQL BuilderAdded Results tab to view query results on the generated statement.
SQL EditorTimed drop down for the Completion proposal (after a period). This time may be modified in the Miscellaneous Options.
SQL EditorAdded Goto Line functionality available from the Search Menu.
SQL EditorAdded ability to execute the editor's contents via SQL*Plus.
SQL EditorCreated an Auto-Save, enabled through the Editor options, which will save the contents of the editor to "AutoSave.sql" every few minutes, as designated in the Editor Options.
SQL EditorAdded Compare Bookmarks toolbar item and menu item.
Statement ViewersAdded a preview pane, visible by toggling the option when right-clicking the viewer. This includes the History List, Pin List, SQL Comparisons List, and any other as such within the application.
Database ConnectionWhen trying to reconnect to a lost session, fixed the error generated for already being in a transaction.
DBMS OutputForced a check if the procedure encounters an error.
DescribeNow displaying both Source and Body Source for Type objects.
DescribeType objects will now display Describe information when they have no attributes.
Describe ObjectWhen describing from the menu item "Describe Object", the remote server name would be incompletely read if a period was present.
SQL BuilderYou will only be prompted to save changes when a change has been made.
SQL EditorShift+Space will produce a space if an entry from Auto Completion was not found.

This high-level enhancement list was generated as of version 2.0.1.3
Additional enhancements and defects corrections may be present in the current version.



Copyright © 2003-2005 Isidian Technologies, Inc. All rights reserved.
Contact Us | Legal | Privacy