I believe that you cannot delete system tables; however, you can delete all the rows from the table. For Rbase 6.5++ for Windows the command would be: Delete rows from SYS_REPORTS2 This will leave you reports table empty and you can reload data from a backup. I hope this helps.
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS 66062-4571 (913)829-0888 (913)649-2904 FAX -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Brad Davidson Sent: Friday, June 14, 2002 10:11 AM To: Rbase List Questions Subject: Rebuilding "Corrupted" Forms Novice maintenance question here.... Looking for a way to clean-up contaminated forms. Entry, Editing of forms is possible, but last week, all forms were populated with character symbols described by users as: small triangles, or "houses", or "tear drops"). Have unloaded, reloaded database, performed r:scope diagnostics, everything else ok in these checks. Attempted to drop sys_forms table, unload/reload a known, good backed-up sys_forms table to the production database. However, am prevented from dropping sys_forms table: "Your cannot delete a system table. ( 10)" Can unload/reload one form at a time and forms are cleaned up. But with over 100 forms, thought someone in this fine list would surely advise a better way! Thanks for any advice on this... Regards, Brad Davidson ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
