Been bitten by that one, too, so I wrote a routine to export the definitions for each form, report & view that runs whenever I do a backup - which is almost more often than I use the database - paranoid moi?
Regards, Alastair. ----- Original Message ----- From: "William Stacy" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, September 24, 2003 10:38 PM Subject: [RBASE-L] - Re: Possible file corruption > Craig Cohernour wrote: > > >I tried your suggestion and AUTOCHK does run > >with no errors now... but, now I'm getting another > >message on some (not all) reports. > > > >-ERROR- Report Definition is incomplete. > > > Ouch! I hate that one. If I recall, every time I get that I have to > completely redo the report. > What I do (from the R prompt) is: > > delete rows from sys_reports where sys_report_name='reportname' > > Then I connect to my last good backup copy that has no such error on > that report, and use: > > output reportname.bak > backup data from sys_reports where sys_report_name='reportname' > output screen > > Then I reconnect to the current database and: > > restore reportname.bak > > and check the new report. If it's ok, reload the database again, just to > be sure. > > That should work. If you don't have a good copy of that report, double > ouch; you have to start from scratch... > Unless someone else knows a way around this. > > bill > > > > >(and... of course, nothing prints for the reports that > >are affected.) > > > >The bank balance is also WAY off now. (This is a > >small accounting system.) > > > >Any other suggestions? > > > >I'm going to restore from backup and try a couple > >of other suggestions I received. > > > >Thanks again! > > > >- Craig > > > >. > > > > > > >
