My advice is to make a copy of your database, then unload all followed by a load, like this
CONNECT <dbname> SET NULL -0- OUTPUT <dbname>.ALL UNLOAD ALL OUTPUT SCREEN DISCONNECT RETURN Then rename the database and load with DISCONNECT SET TRACE ON SET MESSAGES ON SET ERROR MESSAGES ON SET FEEDBACK ON RUN <dbname>.ALL SET FEEDBACK OFF CLS RETURN Use the trace and execute stop on error, then you are able to find out where possible problems are situated. Tony From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: zondag 20 november 2011 21:18 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Report Driving table/Decription Comments Problems Thanks guys, It worked but now I am having problems with the comments (table descriptions) in my tables. Not sure it is related to the report table change, but the comments on different tables keep either changing their description on their own or keep disappearing from the display screen. When I use the design screen the comments are there and re-appear after re-saving the report. But, sometimes the descriptions of columns are switched with the descriptions of the tables. I also had to re-build a table that was apparently corrupted and I even saw a column description I had on the deleted corrupted table now become the table description. Anyone else experiencing these issues? Robert A. In a message dated 11/19/2011 2:04:16 P.M. Eastern Standard Time, [email protected] writes: >From the Reports listing on the DB Explorer menu, select Copy Report, then in the dialog box, change the driving table name, save the report to a different name temporarily, delete the existing report, name your temporary version to the original name. ----- Original Message ----- From: <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Saturday, November 19, 2011 1:58 PM Subject: [RBASE-L] - Report Driving table : How do I change the main driving table on a 9.1 report? : : Robert : --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
