Brad - If your NULL setting is blank when you unload the forms from the original database, you will encounter the problems you have reported. If you follow Buddy's syntax, your file will export and import correctly.
Sami ----- Original Message ----- From: "Brad Davidson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 14, 2002 12:32 PM Subject: Re: Rebuilding "Corrupted" Forms - Razzak's Reply > 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/ > ================================================ 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/
