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/
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
