> (Any idea's anybody?)
>
> create table Positions
> PositionPK INTEGER not null,
> PositionID VARCHAR(12) not null,
> PositionDescription VARCHAR(40) ,
> AuditLastChangedAt DATETIME not null,
> AuditLastChangedBy VARCHAR(31) not null, constraint Positions_PK primary
> key (PositionPK) );
cut.
paste.
run.
works for me. I did have to change "datetime" to "timestamp", being that
"datetime" is not a valid interbase type, unless you have it declared as a
domain.
N
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz