Revisions when migrated to PB7:

1.  Deleted multiplatform support (Win3.1, Mac and Unix), leaving only support for the 32-bit Windows platforms.

2.  Updated references to version numbers and registry entries.

3.  Added support for Oracle 8 (ORA, O84).  Also added support for using database tracing within the utilities.

4.  Added an exit toolbar item for all of the utilities.

5.  Disabled the SPUD utility and corrected the sizing of the initial window.

6.  Added the GetLibraryList method for obtaining the currently library search path to the DWEAS utility.

7.  Revised the PEAR table list to support extended rather than mulit select.

8.  Recompiled the helper DLLs.

Revisions when migrated to PB8:

1.  Recompiled the helper DLLs.

2.  Modified methods used to retrieve database and application information to account for new methods used by PB8.

3.  Replaced references to PFC classes when new native support for certain functions were available (e.g., GetCurrentDirector, ChangeDirectory, etc. )

More revisions (9/6/03)

1.  If a target was under a subdirectory of the workspace, the utility would go into an endless loop when parsing the list of workspaces and targets.  Corrected.

2.  The syntax for getting column infomation from the database catalog was not working correctly for some of the newer database profile names.  Corrected.

3.  If a datawindow did not have arguments, the utility would execute the select statement as-is, which could cause very poor performance.  I modified it so that it adds the 'WHERE 1 = 2' to all datawindows, regardless of whether they have arguments or not. 

4.  If the user modified database preference information other than the DBMS parameter, the utility would store it in the preferences, but would not perform the disconnect/reconnect necessary to make it operative for the current session.  Corrected.

Still More revisions (9/8/03)

1.  If a DataWindow was created with arguments but without a where clause, the DW syntax check utility would replace the entire syntax with the "WHERE 1= 2" statement.  Corrected.

2.  If a DataWindow used arguments in the select portion of the SQL statement, the DW syntax check utility would generate 'not all variables bound' or similar errors.  The utility now replaces those arguments with dummy values.

And still more revisions (3/10/04)

1.  Upgraded to work with PB9.

2.  Corrected handling of PBLs in subdirectories under the target.

Note that the PB IDE only updates the LastUsedTarget for a workspace when the workspace is closed.  Therefore if you change the target within a workspace and then run the utility, it will still show the library list for the previous target.  You need to close (and reopen if desired) the workspace in order for the utility to pick up the change.

The latest (8/17/2006)

1.  Upgraded to with with PB 10.5 (there was a PB10 migration in there somewhere, but I forgot to document it).

2.  Fixed a couple of references to PB9 left over from the PB9 -> PB10 migration

3.  Fixed a missing event declaration in one of the spud windows (even though it's no longer used).

