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
