Razzak, Buddy, Javier - Thanks so much for the reply and advice. The weird thing is I had deleted all 8196 rows of sys_forms table, then unloaded data from good table and reloaded into empty table, and still got the symbols! Anyway, I'll try again - perhaps in the wee hours last night I was dreaming I did as suggested.... will let you know!
Regards, Brad Davidson "A. Razzak Memon" wrote: > 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/
begin:vcard n:Davidson;Brad tel;fax:909-736-4699 tel;work:909-736-4690 x-mozilla-html:FALSE url:www.aero-craft.com org:Aero-Craft Hydraulics, Inc.;Customer Support adr:;;392 North Smith Avenue;Corona;CA;92880-6971;USA version:2.1 email;internet:[EMAIL PROTECTED] title:Manager fn:Brad Davidson end:vcard
