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

Reply via email to