Brad,
You cannot DROP any SYS_ table(s). But, you CAN delete the rows from SYS_FORMS, SYS_REPORTS, SYS_LABELS, SYS_FORMS2, SYS_REPORTS2, SYS_LABELS2, SYS_FORMS3, SYS_REPORTS3, SYS_LABELS3 and SYS_MERGE tables. Before uploading the forms, reports or labels system table(s), you can use DELETE ROWS FROM SYS_tablename accordingly. The R:edoubtable R:BASE 2000 (ver 6.5++) for DOS: SYS_FORMS SYS_LABELS SYS_REPORTS The Glorious R:BASE 2000 (ver 6.5++) for Windows: SYS_FORMS2 SYS_LABELS2 SYS_REPORTS2 The Glorious R:BASE 2000 (ver 6.5++) for Windows (Patch-3): SYS_FORMS2 SYS_FORMS3 SYS_LABELS2 SYS_LABELS3 SYS_REPORTS2 SYS_REPORTS3 SYS_MERGE The Magical R:BASE 7.0 for for Windows: SYS_FORMS2 SYS_FORMS3 SYS_LABELS2 SYS_LABELS3 SYS_REPORTS2 SYS_REPORTS3 SYS_MERGE R:Merge for R:BASE SYS_MERGE Hope that helps! Very Best Regards, Razzak. At 08:10 AM 6/14/02 -0700, you wrote: >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/
