VERSION 0.0: FEBRUARY 1996

VERSION 1.0: JANUARY 1997

VERSION 2.0: FEBRUARY 1998

VERSION 3.0: DECEMBER 1999

VERSION 4.0: NOVEMBER 2000

1. Updated terminology so Temporary files now referred to as Working tables; generally updated references to “files” and “databases” to “tables”.

2. Changed some menu names (Add/Edit à Edit and Housekeeping à Tools).

3. Added functions to toolbar, and ability to reset toolbar on Preferences screen.

4. Significant enhancements throughout WRDB relating to use of SQL Servers (Oracle, MS SQL Server, MySQL).

5. Can specify maximum records to retrieve from SQL server; warnings issued if number exceeded (removed inconsistent timing reports).

6. Enhanced ability to create Working and Master tables on SQL Server (uses fast native import routines or SQL Insert statements).

7. Preferences screen simplified to automatically assign SQL Server alias where appropriate.

8. Enhanced creation of Working and Master tables to allow long, mixed-case file names; project names can now be greater than eight characters.

9. Allowed specification of null password to permanently enable Supervisor access.

10. Updated data structure so LEW_PCT and DEPTH_M fields are numeric, allowing for a true 3-dimensional database. Several forms and reports revised to reflect this change.

11. Length of STATION_ID, STATION_TYPE, and ANAL_NAME fields increased in Stations and PCodes Support files to better support inclusion of STORET and USGS data. HUC field added to Stations support file and QBE query form revised to include this field.

12. Added “Compare Two Tables” file management function.

13. Build group utility developed to interactively edit Station and PCode group tables from WRDB or foreign table (such as BASINS stations query).

14. SQL Query Manager developed to allow manipulation of any data table (WRDB and otherwise). SQL Query Manager can list, display, and print tables and provide example SQL strings. This acts as custom report generator.

15. Added Visual Query Builder for both WRDB and 305(b) tables.

16. DBCONV significantly enhanced to: a) more quickly and automatically import large files, b) more flexibly handle field delimiters, c) recognize and convert STORET Stations, PCodes and RCodes, d) allow automatic conversion of PCodes and Station IDs, e) created DATE-HOUR import format

17. Remove Import EPD Lab option, because OmniLab program no longer used at EPD.

18. Multi-parameter entry sequence streamlined.

19. Calculate DO Saturation modified to operate only on selected data, rather than on entire Working file.

20. Added Calculate New Data, a general purpose method for calculating and adding observations from existing data.

21. Added Calculate Dissolved Metals function.

22. Added Edit Data in Grid form.

23. Advanced query form enhanced to handle large numbers of stations and PCodes, and to query from group files.

24. SQL Query form simplified (function column removed).

25. All report forms and printouts revised to better display long Station IDs. Report forms revised so keyboard can be used to scroll.

26. 305b, SQL Manager, and WRDB reports can preview reports and send to RTF file readable by word processing programs.

27. Designed additional reports and reorganized report menus.

28. Designed “Sort by Heading” form and report that allows user to pre-specify headings and PCodes to print in cross-tab report.

29. Added Custom Reports add-in using Crystal Reports from Seagate Software.

30. All graphing significantly enhanced to provide more flexibility in formatting and printing. Added “fit sine curve” capability. Station ID and PCode list boxes show full names as tooltips. Added Copy To Clipboard.

31. GIS form enhanced to handle larger number of stations, search for and display stations information, manipulate basemap layers, and extract data from WRDB. Added menu system to simplify program use.

32. GIS form enhanced to display ArcView themes (loading SHP and APR files) and load, georeference, and display DBF files. Can now export WRDB stations to ArcView Stations file. Increased number of formatting options.

33. Significantly enhanced 305(b) module, adding multi-user access, spreadsheet-style reach input form, reports, compiling assessments, identify exceedances, TMDL tracking, GIS reach display, and much more.

VERSION 4.1: FEBRUARY 2001

VERSION 4.2: JULY 2002

VERSION 4.3: OCTOBER 2002

VERSION 4.4: MARCH 2003

VERSION 4.5: APRIL 2004

WRDB Revision History: