IBConsole is known to be a bit flakey in its parsing for semicolons, but I
haven't encountered this one before. For a while if you wanted to insert a
semicolon into a field, IBConsole ignored the first one, eg.
Insert into MyTable values ('a ; b ; c');
/* Inserts 'a b ; c' */
Solution being to replace the first semicolon with two of them. I don't
know if that one has been fixed yet.
Perhaps WIBSQL might be better at running your scripts.
Cheers,
Carl
-----Original Message-----
From: Myles Penlington [mailto:[EMAIL PROTECTED]]
Sent: Monday, 9 October 2000 1:30 PM
To: Multiple recipients of list database
Subject: RE: [DUG-DB]: IB6 - ISL/IBConsole.
Thanks for the comments, but I had done all the conversion of the SQL to
dialect 3 already - turns out to something far more subtle ...
Looks like it is a bug in the ISQL/IB parser. The line number reported is
misleading - it is actually the line number -1 of the next DML statement.
The script file has a single space after the terminating ";" on each
statement - and this causes this error to be thrown - remove the space and
all works okay. (as to why I have no idea, @%$$ frustrating )!!!! By the way
this only happens if you have two DDL statements present - a single
statement does not cause the error - and the last DML statement can have a
trailing space ...
(Any idea's anybody?)
Thanks
Myles.
-----Original Message-----
From: Nic Wise [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 3:01 PM
To: Multiple recipients of list database
Subject: RE: [DUG-DB]: IB6 - ISL/IBConsole.
Quite sure its not something a little further down? Line 14 char -1 would
indicate its not the first block....
?
N
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Myles Penlington
> Sent: Monday, 9 October 2000 14:49
> To: Multiple recipients of list database
> Subject: [DUG-DB]: IB6 - ISL/IBConsole.
>
>
> I am about to start spitting tacks ...
>
> After installing IB6.01 (all okay and migrate a DB from IB5.5 all okay), I
> am now trying to use the previous scripts (100K+) to re-create the DB with
> IB6/ISQL - which of course fails - does not recognize the "Create table".
>
> Dynamic SQL Error
> SQL error code = -104
> Token unknown - line 14, char -1
> create
> Statement: create table Positions
> PositionPK INTEGER not null,
> PositionID VARCHAR(12) not null,
> PositionDescription VARCHAR(40) ,
> AuditLastChangedAt TIMESTAMP not null,
> AuditLastChangedBy VARCHAR(31) not null, constraint Positions_PK primary
> key (PositionPK) )
>
> Anybody know what is going wrong - what has changed??? Or is this just
> another bug in IBConsole/ISQL?
>
> Regards,
>
> Myles Penlington
> Software Engineer
> Advanced Management Systems Ltd
> www.ams.co.nz/email
> DDI 4885514
> Mobile 021-488-514
>
> ------------------------------------------------------------------
> ---------
> New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
