WRDB Revision History--3.0

1. Modify all forms to conform to Windows 95 visual standards. Form colors now conform to Control Panel settings. WRDB will no longer be distributed for Windows 3.1.

2. Toolbar redesigned to include more often-used commands.

3. Watermark (background bitmap) can now be specified on the Preferences screen.

4. Modified Tracking file structure to handle long file names and index on Temporary File name.

5. Update Support File Structures checks all Support files and upgrades their structures as needed.

6. Update Temporary File Structures does batch structure update on all files in Temporary directory.

7. Delete Duplicate Records functionality added for Temporary and Master files.

8. Change Selected Records functionality added for Temporary, Master, and Support files.

9. Added Replace button to Support file browser.

10. Can now set Private directory from within WRDB.

11. Compact Temporary file form now stays on screen so multiple files can easily be handled.

12. Access to BDE Adminitrator and File Repair utilities from File Management menu.

13. Opening Alternate files facilitated by using persistent directory names.

14. Extensive Y2K testing performed on all components.

15. Calculate DO Saturation routine developed to do batch computation of DO saturation, percent saturation, and DO deficit.

16. Enhanced DBCONV program to greatly increase import speed (50 times faster).

17. Added COLUMNAR keyword to facilitate and speed import of raw data.

18. Invalid Station IDs in import file don’t cause fatal error; will automatically add unrecognized IDs to support file if desired.

19. Can optionally specify whether space-delimiters are allowed in import files so text with spaces (e.g., station names) doesn’t need to be quote delimited.

20. Added STATION_ID keyword to DBCONV to facilitate tabular import of large files from multiple stations.

21. Added new DBCONV column headings YEAR, MONTH, DAY, HOUR, MINUTE to facilitate import of large files (don’t need to load into spreadsheet to compute dates).

22. Can import UNIX line-feed delimited files.

23. Allow scientific notation in import files.

24. Allow decimal dates in import files.

25. Added intelligent interpretation of two digit years based on current date.

26. Import progress bar now has cancel button.

27. Downloaded and compiled large “program” master data files from STORET, USGS, and NWS.

28. Improved multiple parameter input form.

29. Improved round-trip transfer of data (export, modify, import).

30. Added Import Data File feature to allow very fast direct import of Oracle, spreadsheet, database, and text files (10 times faster than new DBCONV).

31. Checks added to assure maximum Paradox database size not exceeded and gives instructions on how to increase the table block size.

32. Revised data entry throughout WRDB to allow entry of 2- or 4-digit years.

33. When WRDB automatically closes and reopens browser their position is maintained.

34. Display Selected Data option added to display currently selected data in its own browser along with the applicable selection criteria.

35. Print Selected Data report designed for quick listing of selected data.

36. Create new Advanced Query form that allows interactive selection of multiple Stations and PCodes as well as helps with date queries. Former Advanced Query form retained as QBE Query form. Neither form requires Supervisor access.

37. Create new SQL Query form that interactively builds powerful SQL queries.

38. All printed reports test for excessive number of pages to be printed so user can be warned.

39. Each report retains individual report comments for a given project.

40. All file export options are now persistent.

41. Export files now include column headings.

42. Added warnings regarding importing and exporting from/to Microsoft Excel.

43. Completely rewrote GIS module; is now raster-based with thematic mapping and ability to import AutoCAD DXF files.

44. Added animation capabilities for Longitudinal Profile and Time Series graphs.

45. Added lines through average values to Longitudinal Profile graphs.

46. Added logarithmic scaling to graphs and manual scaling options for scatter plots.

47. Added ability to set logarithmic PCodes so Graph program automatically applies log scaling to specified parameters.

48. Optional display of criteria ranges as lines on Graphs for time series, profile, scatter, and frequency graphs.

49. Specify comments to print on graph.

50. Report previews include Save button to export results to a variety of file formats.

51. Report screen previews and data browsers include Copy to Clipboard buttons or option to quickly place unlimited number of records on clipboard.

52. Report previews and graphs are non-modal, allowing multiple reports and graphs to be open at one time.

53. Summarize reports enhanced to quickly and correctly analyze very large files (over 250 Mb in size).

54. New Visual Basic compiler now removes 32k limit on number of observations to plot.

55. Developed Add-In Manager to load and unload optional add-in modules.

56. Developed 305(b) add-in module prototype to track and report reach violations.

57. Multi-user access improved; added descriptive messages; added Display File Locks to File Management to show names of users accessing Temporary and Master files.

58. Oracle access fully implemented using SQL Links; SQL Server Configuration added to Preferences to maintain WRDB SQL usernames and passwords.

59. Past query performance used to estimate amount of time to retrieve Oracle data; user is notified if excessive time is required.

60. Can open Oracle tables as Alternate files.

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

VERSION 4.3: OCTOBER 2002

VERSION 4.4: MARCH 2003

VERSION 4.5: APRIL 2004