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 >> >>. >> >> � >> > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ McAfee VirusScan Online from the Netscape Network. Comprehensive protection for your entire computer. Get your free trial today! http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
