[RBASE-L] - Re: Possible file corruption

[William Stacy]

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

.