History

April 26, 2006 - v2.0.0.7:

Enhancements:

ADS 8 support (ADS 7 is not supported by ADS LogManager 2). Basically, ADS LogManager 2 takes advantage of the following new features in ADS 8.

SQL scripting in triggers allows us to use a more flexible logging data model
Using the sp_GetApplicationID() stored procedure to log the application name
Using the sp_DisableTriggers()/sp_EnableTriggers() stored procedures to temporarily disable/enable log triggers

Revamped GUI
Scripting facility implemented. The ADSLM 2 scripting engine can be used to automate repetitive tasks in a script based way. Detailed information can be found here
Temporarily disable logging without removing logging definition
Logging options can be defined per project in the Connect to Database dialog now. The logging options in the Logging Options dialog serve as default values when creating a new project
Logging options for a project can be stored now without the need to reconnect
New command line switches -i and -nosplash have been added. Use -i to specify the configuration file ADS LogManager 2 should use. If -i is omitted, then adslogmanager2.cfg is used. Use -nosplash to omit the splash screen at program start
PNG and GIF support in BLOB viewer added
Position and width of BLOB viewer window gets restored
Filter settings are persistent now

Bugfixes:

Bug fixed: Enabling automatic record count without being connected does not throw an error anymore.
Bug fixed: Logged field values are casted with sql_varchar now (previously sql_char).
Bug fixed: Fixed an AV which occurs when clicking on the title of the log data grid without being connected to the database.
Bug fixed: English captions are used for buttons ... in message dialogs now.

November 2, 2004 - v1.1.0.6:

Enhancements:

The ADS LogManager product family comes now in two versions, depending on the ADS version (7.0 or 7.1) you are using. Make sure that you are downloading and using the right package!
TDataset/ACE version information is shown in the About dialog.

Bugfixes:

Bug fixed: Error message "Listindex überschreitet das Maximum (1)" when connecting to a database has been fixed. This happened when using the ADS 7.1 client libraries or Advantage Local Server 7.1.
Bug fixed: Blanks in user and group names are handled properly now.

April 14, 2004 - v1.1.0.5:

Enhancements:

Multi-Select in data grid via check box.
Hitting the space bar in the log data grid will toggle the "selected" state.
"Select All" and "Unselect All" in data grid's context menu has been added.
New option "Single DELETE statement with current filter criteria" added in the Options-Dialog. This enables one to specify whether "Delete all records" will execute a simple DELETE FROM ... statement with the current filter criteria (option = checked) or deleting all records by iterating through the result set (option = unchecked).
Log type filter criteria has been added.
Explicit usage of the NO MEMOS keyword for trigger creation, if there aren't any LOB (= Large Object; MEMO, BLOB) columns registered for logging.
Enhanced GUI regarding existing INSTEAD OF triggers. Table, operation and column nodes in the treeview, are displayed differently, if there is an INSTEAD OF trigger defined for a table/operation. This is useful to see, whether the execution of an existing AFTER log trigger will be omitted or not.
A new "Tables with INSTEAD OF trigger(s)" option has been added to the treeview filter facility.
Online-Help updated.

Bugfixes:

Bug fixed: The "Show Warning after analyzing a partial logged database" option works as expected now.

November 27, 2003 - v1.0.1.5:

Enhancements:

NULL column states in the log data grid are shown as '' in blue color now.
The "remember password" option in the "Connect to Database" dialog has been deprecated for enabling the quick access for projects in the main form, e.g. by using the "Recent Projects" menu item or the drop-down box. Use the new option "Quick Project Access" instead. For upgrading existing projects that should be quickly accessible, simply open the "Connect to Database" dialog, choose the project and click "Ok". The new option is stored in context of the current project now.
Online-Help updated.

Bugfixes:

Bug fixed: Empty passwords in the "Connect To Database" dialog are allowed now. That means, the "Ok" button gets enabled, even when the password is empty.

November 17, 2003 - v1.0.1.3: Final Release

Enhancements:

Only dictionary aliases are selectable from the alias drop-down box in the "Connect to Database" dialog now.
ADSLMViewer a "Read-Only" version of ADS LogManager for browsing/exporting/printing logged data, but without the capability to change the logging schema is available.
Minor enhancements in the installer.

Bugfixes:

None

November 9, 2003 - v1.0.0.6 RC1:

Enhancements:

Some minor textual and visual tweaks in different dialogs (prepare wizard, unprepare wizard, options, ...).
Print facility has been hided in the main menu. Printing of log data will come in one of the next releases after the first final release.
Online-Help available.
Full installer available.

Bugfixes:

None

November 4, 2003 - v1.0.0.5 BETA:

Enhancements:

I'm using the freely available TSMDBGrid from Mike Shkolnik (http://www.scalabium.com) for the log data grid now.
- Font and background color are using the settings as specified in the Options dialog (tab "Logdata") now.
- Sort order can be specified by clicking on the grid title. This can include serveral columns.
- Grid layout (column position/width, sort order ...) will be stored project-based in the registry.
- Context menu item "Grid setup..." helps you to define the grid layout
During the prepare process, there will be two new columns OLD_VALUE_MEMO and NEW_VALUE_MEMO (both of type MEMO) in the log table created. It is necessary to use separate columns for storing BLOB/MEMO data, because there is no way to store a MEMO in a BLOB column through a regular DML statement.
The BLOB/MEMO Viewer is available now. When there was a BLOB or MEMO column logged, you are able now to view the content of the corresponding old/new values in a BLOB/MEMO Viewer by simply double-clicking in the log data grid, or by using the log data grid context menu.
Some enhancements in the "Connect to Database" dialog.
- It is now possible to connect via a dictionary alias.
- Username is now editable
- Projects can be deleted with the button beside the drop-down box.
Links to the ADS LogManager newsgroups has been added in the "About" dialog.

Bugfixes:

Logging MEMO columns works now as expected. See also enhancement 2)
CAUTION: You have to unprepare/prepare the database with this version, and to redefine your logging schema!

November 2, 2003 - v1.0.0.4 BETA:

Enhancements:

The Export/Import Logging Definition facility has been ported from IB LogManager. See the "File" menu. You are able to export/import the logging schema into/from a text file. This useful, especially when working with databases having a similar structure, and if you want to have the same logging schema in a number of databases.
The Export Logging Metadata facility has been ported from IB LogManager. See the "File" menu. Use this feature on a prepared database to export the logging metadata into a SQL script file.
Double click in the treeview on a table node registers/unregisters the entire table now.
Minor textual tweaks in the Prepare-Wizard.
Minor GUI tweaks.

Bugfixes:

Bug fixed in the Prepare-Wizard when loading/saving logging metadata notations.

October 30, 2003 - v1.0.0.3 BETA:

Enhancements:

The log data grid toolbar is fully functional now.
This includes:
- Navigation: First, Prior, Next, Last
- Delete selected log data
- Delete all records
- Export log data
- Open log data
- Load/Save selection (search criteria)
Context menu for log data grid has been implemented.
Menu items and context menu for showing/hiding toolbars added.
Help menu item added. This is still work in progress, because there isn't a help file available right now.
Database Information dialog has been added. See File/Database Information...

Bugfixes:

None

October 28, 2003 - v1.0.0.2 BETA:

Enhancements:

Support for logging BLOB data. Due to a restriction of SQL script based triggers, real changes aren't detected, and BLOBs are logged whenever a BLOB column is registered for logging.
Logging schema statistics in the left bottom corner added.
Partial logged warning message available (check out Options-Dialog).
Table descriptions are shown now.
Treeview context menu added.
Querying metadata has been optimized.

Bugfixes:

The "Members Of" search criteria has been fixed.
The "Automatic" option for automatically counting the number of records in the log data grid has been fixed.