Brad -
I see what you mean - Buddy's last command should have been:
RUN output.dat.
The command "RUN" runs the set of all commands contained within a text file
(command file) or application file. This text file could include a
statement with the LOAD command.
LOAD only loads data into a table from some source. If the source file is
an ASCII data file only, with NO R:BASE commands included, then you can use
the LOAD filename syntax as in:
LOAD tablename FROM filename ...
To see what I mean, open the file you created, "Output.dat" and read the top
30 lines or so. You will see a bunch of SET statements, then a LOAD
statement then way down near the bottom, and END statement which will end
the loading of the block of data, then some more SET statements. When you
tried to LOAD your output file, R:BASE was expecting plain old ASCII data -
not a bunch of SET statements and other R:BASE commands.
Hope this helps!
Sami
----- Original Message -----
From: "Brad Davidson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 14, 2002 3:11 PM
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
================================================
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/
