Missing database field
-
- Posts: 170
- Joined: Tue Oct 10, 2017 12:44 pm
Missing database field
Is there a way to make R&R continue even if a database field is missing from the database table? (run thru the .dll, not interactively). My users might make minor changes to the names of the table fileds and this stops R&R cold. ____Alternatively, is there an easy way to get a list of field names used in the report that can be checked against those in the .mdb file?____Thanks,
=> RE: Missing database field
Changed field names do indeed cause a problem.____In Version 9, the Report Librarian is an easy way to report on the fields that are used within a report.____In earlier releases, it is a good idea to keep a archive of report specifications as you design reports.______Kathleen__R&R Support
-
- Posts: 170
- Joined: Tue Oct 10, 2017 12:44 pm
==> RE: Missing database field
How does the report librarian work? Is it just a list of fields used in the report, or is it a function that can be called to retrieve those names programmatically?____Thanks
===> RE: Missing database field
Each time you save a report in Version 9, the Librarian writes information about the report contents to a series of database files. There are a variety of predefined Report Librarian reports that you can run to view report data.__The Librarian gets installed to the RL subdirectory.__The default login ID for Librarian is ADMIN with no required password.____Kathleen__R&R Support