JM,
If this is in a codelocked file then I think the ; causes the commands to be
put on a new line. For some reason the ; command delimiter is split onto
separate lines when codelocked. I found this in 4.5++ trying to rebuild an
autonumbered table I think. It was a while ago and the antient mind is a
little fuzzy.
Regards
Clive Williams
Sydney Australia
----- Original Message -----
From: "J.M. GRATIAS" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 19, 2001 4:47 PM
Subject: Re: Issue with LOAD command
>
> Bill :
>
> >>
> What is your DELIM character? If it is not ";" that could be your
> problem.
> <<
>
> No, it is not.
> DELIMIT is set to ',' (comma), as usual in standard setting.
>
> But :
>
> LOAD TableName FROM FileName , NOCHECK, NONUM
>
> return error 2045 (Syntax is incorrect).
>
> It seems that the rigth syntax is
>
> LOAD TableName FROM FileName ; NOCHECK ; NONUM
>
> whatever is the DELIMIT setting ...
>
>
> J.M. GRATIAS, Logimatique, France
