Brad Sami gave you a good explanation about the difference between load and run. It should have been run, I'm in the habit of unloading data as ascii and then load the data back into a table.
One other tidbit that may help, I always set the NULL to -0- before loading/unloading any data Buddy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Brad Davidson Sent: Friday, June 14, 2002 4:11 PM To: [EMAIL PROTECTED] Subject: Re: Rebuilding "Corrupted" Forms - Razzak's Reply That was it Sami - setting null to -0- first. Thanks! Everything fine, as long as I use RUN filename, not LOAD. So, the question, how is 'run' versus 'load' used (e.g. Buddy's suggestion)? For instance, if I use Buddy's command sequence using "load sys_forms from filename" get several error messages, such as: "Column sys_form_seq must be a valid integer ( 122)" (repeated twice). And, "More than 5000 characters or 400 items on input line ( 14)". And, "Incorrect number of values for this table ( 118)." And, no rows are loaded to table sys_forms. But, if using RUN executable, no error messages, and all rows of data loaded fine, forms good... Thanks again for the lesson! Regards, Brad Davidson Sami Aaron wrote: > 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/ ================================================ 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/
