I tried this statement in IBConsole and it worked for me. I suggest that
the problem is in the statement prior to this one - is something not
terminated correctly? I notice that this statement doesn't have a semicolon
at the end...
Cheers,
Carl
>From: Myles Penlington [mailto:[EMAIL PROTECTED]]
>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) )
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
