Release History: dbAnalyst

• Schema Display Form
  • New Features
    • Changed object script display from static display to dynamic (hot) display of objects:
      • support for object navigation,
      • support for context sensitive help,
      • support for dependency object navigation.
    • Added navigation to Online Help Form. Added top online help navigation.
  • Defect Fixes:
    • Fixed dependency display, for object having only 'to' dependencies.
    • Added HTML tags filtering/stripping for object scripts for script execution.
    • Fixed: When executing a bad SQL stmt, the code throws the wrong exception on the next statement / following command because record set is null.
    • Fixed object collective display
    • Fixed bad character in XML display
    • Deleted temporary file used for HTML output when closing Schema Display Form.
• SQL Console Form:
  • New Features
    • Added navigation to Online Help Form. Added top online help navigation.
• Preference Panel
  • New Features
    • Schema Display Form: added support for coloring of HTML Display, HTML anchors.
• Online Help
  • New Features
    • Added support for online help. Added support for context-sensitive help display.
• Scripts
  • Oracle10g 10gR2: Added top menu help and context sensitive help
  • MySQL 5.0:
    • Created support for MySQL 5.0, including tables, indexes, view, functions, procedures & triggers.
    • Added support for object editing
    • Added top menu help and context sensitive help.
  • PostgreSQL 7.3: Added top menu help and context sensitive help
  • Microsoft SQL Server 2005: Added top menu help and context sensitive help

• Overall:
  • Speed up data retrieval by removing pause during fetch operation.
  • Added connection string label to login window.
  • Fixed Version Check on splash screen.
• SQL Console Form:
  • New Features
    • Development of Intellisense v2:
    • Better SQL parsing
    • Better forecasting of next object
    • AbILITY to suggest indexes by statement parts
    • Added Index Retrieval at Startup. Scripts changed: PostgreSQL 7.3 .xml, Oracle9i 9.2.xml, Oracle9i 9.0, 9.1.xml, Oracle8i 8.1.6 .xml, Oracle8 8.0.5 .xml, Oracle10g 10gR2.xml
    • Removed Pause & Restart buttons
  • Defect Fixes:
    • Fixed find & replace syntax editor functions.
    • Fixed SQL statement parser: optimized parse speed for large amount of text.

• Overall:
  • Fixed unconsistencies with Vista, especially animations and toolbar issues.
  • Fixed MDAC version check.
• SQL Console Form:
  • New Features
    • Added ability to select a table name and quickly see table columns.
• Schema Display Form
  • Defect Fixes:
    • Fixed export query output to file, where file dialog box does not display .CSV files until 'Save as type' *.*
• Database Spy Form.
  • Defect Fixes:
    • Fixed code when required COM object for database spy is not registered.
  • New Features:
    • Development of Database Spy SFTP mode.

• Overall:
  • Created *Free* dbAnalyst and *Professional* dbAnalyst versions
  • Changed and improved registration scheme
  • Improved remote registration via web services
• Schema Display Form
  • New Features
    • Added Metarialized View Support
    • Added token mathcing by string in addition to set member
    • Improved Error messaging
    • Fixed Nullable boolean default values for table editor

• Overall:
  • Changed code completion to Autocomplete
  • Replace Database Spy by Database Spy name and SQL console to SQL Query Console
• SQL Console Form:
  • Data Access Layer:
    • Fixed Trace Status state
    • Changed fetch routine: Fixed Postgres 'movenext' fetch mode.
  • IntelliSense:
    • Fixed issue when 'drop' is now a token, __DROP
    • Added parsing of a. and then poping up column list
    • Added drawing of 1, 2, 3 lines given portion of intellisense
    • Removed Home/End keys for IntelliSense

• SQL Console Form:
  • IntelliSense:
    • Added color to line
    • fixed end trim
    • activate intellisense only if white space, comma.

• SQL Console Form:
  • IntelliSense:
    • Added delay in seconds (set by preference) before intellisense display.
    • Parsing: Add left/right inner/outer joins sql parsing, Added else statement to case statement.
    • Revised drawing of IntelliSense.
    • Fixed parser for better parsing during exceptions.
    • Fixed toolbar not finding control bar defect.

• SQL Console Form:
  • IntelliSense:
    • Changed object display by zone
    • Revised object search algorithm
    • Added Pseudocolumns
    • Fixed statement parsing for 'in' clause
    • Centralized cursor mgt

• SQL Console Form:
  • New Features
    • IntelliSense:
      • Code completion features enabled for Select, Insert, Update, Drop, Delete, Truncate, Describe statements
      • Added preferences for popup dismissal, and timer value for popup dismissal.
      • Added code completion object list refresh command.
      • Added IntelliSense color preference. for the popup window
    • Added 'Execute Block' function: Ability to select a block of text and execute it as such with parsing for ';'.
    • Added vertical bar feature: the top window left hand side shows the extent of the SQL statement being worked on.
      • Added execution tab vs script tab color. Added preference for script tab color.

• SQL Console Form:
  • New Features
    • Added IntelliSense-type feature to SQL Console.
• Scripts
  • Added IBM AS400 iSeries script support

• Overall:
  • New Features
    • Changed File menu 'Preference' string to 'Options'
    • Updated format of preference form.
    • Upgraded preference panel (colors & font selection) to be WAY prettier. :-)
    • Release Notes are now in HTML format.
• Schema Display Form
  • New Features
    • Changed instance data display from XML to HTML for user readability
• Scripts
  • Fixes
    • MaxDB: Changed MySQL references to SAP: Control over MaxDB turned over to SAP by MySQL A.B.

• Overall:
  • New Features
    • Added MDAC Version Check: MDAC must be 2.7 at a minimum.
    • Added upper case option to connection wizard
    • Added comment to ado connection parameters, allowing to specify driver download details for example in Connection wizard.
• Preference Panel
  • New Features
    • Preference panel is tabbed to the preference for the form that called the preference panel.
    • Fixed Prefence Panel display blanking out when hovered with mouse
• Schema Display Form
  • New Features
    • Revised MDAC access to be faster than 1 record at a time.
    • Extended Data Export to include SQL Insert stmts
• SQL Console Form
  • New Features
    • Added confirmation when closing Console window.
    • Added Preference to ask for conformation when closing window.
• Log Tracer
  • Fixes
    • Fixed Log Tracer Connection bug
• Scripts
  • New Features
    • Added SAP MaxDB 7.6 Script
    • Added Ingres 2006 Script
  • Fixes
    • Microsoft SQL Server 2005: Added trigger dependencies to tables

• SQL Console Form:
  • New Features
    • Added Last Recently Used File List to Schema Console
    • Added Windows version handling for object display
  • Fixes
    • Fixed refresh and delete on log file list

• Overall
  • Fixes
    • Fixed Critical error with CustomToolbar Panel display
    • Fixed refresh and delete on log file list

• Schema Display Form
  • New Features
    • Added 'Data Errors' tab to bottom tab panel to reflect errors that have occured in the data grid display.
    • Added Package & Exception syntax hiliting keywords
    • Switched Highlighting component from PlusMemo to SynEdit
    • Changed display to have 3 panels.
    • Display Errors when setting a trace.
  • Fixes
    • Fixed Line Number in Log Trace HTML Output when doing reloads
    • Fixed multiple load that are not necessary.
    • Revised Cursor handling.
    • Set Main Query Result as readonly
    • Fixed Cursor setting in objects that do not like to be cursor changed
    • Removed auto-focus
• Connection Wizard Module
  • New Features
    • Added db Connection and FTP Connection Test
  • Fixes
    • Fixed Switching of database setup for Connection Wizard Form.
• Database Spy Form.
  • New Features
    • New Database Spy Form developed
    • Fixed Form Selection
    • Enabled FTP Access

• Schema Display Form
  • Fixes
    • Modified Right Hand side Display, using a Web Browser control: disabled default IE popup menu, and speeded display of text.
• SQL Console Form
  • Fixes
    • Fixed paste & locad from file operations that would not refresh field display.

• SQL Console Form
  • Fixes
    • Removed Object selection by moving mouse above field.
    • Fixed selection clipboard bug.
    • Fixed Focus Problem

• Overall
  • New Features
    • Created script for Oracle10g 10gR2
    • Web service -based user registration
  • Fixes
    • Fixed error display to replace unreadable chars with \n, \r, \t
    • Resolved double logging of SQL stmt
    • Resolved exception when attempting to close lost connection
• Connection Wizard
  • New Features
    • Fixed command execution for menu items, for Oracle connection type
• Schema Display Form
  • New Features
    • Added Field Focus (left side, right side or bottom field object) given mouse move action.
    • Added icon for display of Line/Col information at the bottom of the window, status bar panel.
    • Added Recycle bin object
    • Added posibility of alternate icon for schema with no resource
  • Fixes
    • Revised proxy user icon
• SQL Console Form
  • New Features
    • Added icon for display of Line/Col information at the bottom of the window, status bar panel.

• Overall
  • Fixes
    • Fixed login procedure, if login procedure regards OCI and login screen is not required.

• Overall
  • Fixes
    • Grid object: fetching of data should happen by block of 200 rows. This behavior was affected by the New database abstraction layer and reestablished.

• Overall
  • New Features
    • One-Connection/Shared connection feature development.
    • New database abstraction layer development: Implemented Oracle OCI connection possibility as an alternative to connecting using MDAC/ADO for connecting to Oracle.
• Connection Wizard
  • New Features
    • Added ability to select if one or many connection are used per login. By default, many connections are used.
• Schema Display Form
  • Fixes
    • Smoothed display/ reduces flickering of grid data and text display
• SQL Console Form
  • Fixes
    • Smoothed display/ reduces flickering of grid data and text display

• SQL Console Form
  • New Features
    • Added current line background color to console command panel
    • Added executon tab for SQL execution point
    • Added preferences for current selected line (enabled & color)
    • Added color preference for command panel Execution Tab

• SQL Console Form
  • New Features
    • Added SQL Console conditional display of text output header & footer

• SQL Console Form
  • New Features
    • Added Console Form Command and Output panel proportional resizing if corresponding preference check box checked.
    • Added ECHO command to SQL Console Tool
  • Fixes
    • Fixed Column resizing and column dsplay in empty query

• SQL Console Form
  • Fixes
    • Speeded up display of SQL statement results in SQL console lower panel
    • Fixed exexute to data output to allow several statements to be executed at once
    • Allowed Analyze statement feature to be able to analyze several statements at once.
• Overall
  • Fixes
    • Execute to Output: Revised HTML output to look better

• Overall
  • Fixes
    • Fix toolbar button height
• SQL Console Form
  • Fixes
    • Fixed lower quadrant scrolling glitch.
    • Fix Data dump error handling (or lack of)

• Schema Display Form
  • New Features
    • Added Has() script function
• SQL Console Form
  • New Features
    • Added ability to load and save command upper quadrant sql text as files
    • Added ability execute as output, to export sql statement content as text file
  • Fixes
    • Fixed Character filtering above char 127
• Database Connection Form
  • Fixes
    • Fixed slowness when showing the connection popup.

• Schema Display Form
  • New Features
    • Added Statistics to Summary Page
    • Added Indexing scheme to reverse engineering
    • Schema Comparison Feature:
      • Completed Schema snapshot feature
      • Completed Schema comparison Feature
    • Changed GRANT assignments; Grants are now individually attached to each object (tables, views, packages, etc)

• Schema Display Form
  • New Features
    • Schema Compare function in development

• Overall
  • New Features
    • Migrated to Delphi 2006
    • Revised user interface to look XP-ish! (Toolbars, Icons, Removed Open icon / Rename Conenct icon to Open icon)
    • Added short cuts to buttons
  • Fixes
    • Fixed Initial Visible issue in D2006
    • Fixed Panel issues in D2006
    • Revised and cleaned up option page for SQL Console & Schema Explorer tools.

• Overall
  • New Features
    • Changed Appearance of Graph Panel
    • Scroll Graph Panel in view so that selecting a panel displays panels in view
• Database Connection Form
  • Fixes
    • Renamed 'Update?' check box to 'Default?

• Overall
  • Fixes
    • Revised user manual for 3.0.
    • Fixed 'clicking on any child window will maximize child window' bug.
• Database Connection Form
  • New Features
    • Added the ability for the connection login window to select if parameter changes should be saved to disk, using the 'Default' check box
• Schema Display Form
  • New Features
    • Added SAX XML Parser
    • Revised Appearance of Graph Panel
    • Scroll Graph Panel so that selecting a panel displays panels in view
  • Fixes
    • Fixed 'Clicking to expand a tree node in modeless window from child window expands twice (i.e. expand and collapse) node'.
• SQL Console Form
  • New Features
    • Memorization of SQL statements: Memorize function allows for SQL statements to be either all memorized. Added Memorized SQL statement palette window.
    • Added Tabbed display to the console result panel
    • Adding the ability to dump data into file or clipboard

• Overall
  • New Features
    • Enabled 'Windows XP' look.
    • Added SQL String Name into the SQL Log window
  • Fixes
    • Fixed glaring issues with syntax highlighter.
• Database Connection Form
  • New Features
    • Added connection parameter storage as XML
• SQL Console Form
  • New Features
    • Implemented 'Favorite Query SQL.xml' storage of user favorite queries.
• Schema Display Form
  • New Features
    • Added proper (stack based) cursor management.
  • Fixes
    • Reworked schema reverse engineering to significantly reduce loading time.
    • Removed Schema Caching.
    • Fixed timer issue for Graph display
    • Fixed Context switching between tabs.
    • Re-Enabled Alert computations!
    • Implemented new feature supporting HTML page display for all objects.
    • Fixed issues around drawing of check box for graph display
    • Fixed Schema Translation
    • Fixed Import process for v3.0
    • Changed CRLF Filtering
    • Removed Force Graphing and Schema Graphing options to logging
    • Fixed flashing in treeview navigation display
    • Postgres: Changed GetRows to row by row to handle varBinary Format
    • Changed Dependency Algorithm, to be mostly db -driven and simple-meta data relationship driven
• Scripts
  • New Features
    • Completed MySQL for dbAnalyst 3.0
  • Fixes
    • Revised all scripts to handle new reworked schema reverse engineering scheme.

• Schema Display Form
  • New Features
    • Added 'Find Object/ Feature
    • Added binary streaming to reduce XML loading time
    • Revised meta data to instance data indexing scheme
  • Fixes
    • Optimized reverse engineering loading time using GetRows()

• Database Connection Form
  • New Features
    • Added possibility to select the Database provider when creating a database connection.
    • Connection Edit screen now allows for field default value.
    • Connection List Form: Fixed Connection Column
• SQL Console Form
  • Fixes
    • Fixed Syntax Hightlighting (PlusMemo) handling when pressing Ctrl V / Ctrl X / Ctrl Z / Del / Backspace / Enter keys.
• Schema Display Form
  • New Features
    • Added possibility of encryption for instance data streaming
  • Fixes
    • Fixed GPF when refreshing part of the tree
• Scripts
  • New Features
    • Added Microsoft OLE DB Provider for Oracle Support