Missing database field

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
FRED_EMMERICH_(Guest)
Posts: 170
Joined: Tue Oct 10, 2017 12:44 pm

Missing database field

Post by FRED_EMMERICH_(Guest) » Fri Aug 31, 2001 10:34 am

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,

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Missing database field

Post by kfleming » Fri Aug 31, 2001 1:05 pm

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

FRED_EMMERICH_(Guest)
Posts: 170
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: Missing database field

Post by FRED_EMMERICH_(Guest) » Fri Aug 31, 2001 1:27 pm

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

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

===> RE: Missing database field

Post by kfleming » Sat Sep 01, 2001 12:30 pm

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

Post Reply