[RBASE-L] - Re: Possible file corruption

[William Stacy]

You're right, I forgot about that because I never use anything else but -0- for nulls. Why would anyone??? bill Albert Berry wrote: One absolutely necessary step when reloading is to R> SET NULL -0- before reloading. Forms and reports corrupt wildly if one does not do this. William Stacy <[EMAIL PROTECTED]> wrote: 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 .