Hi,

> Create a database test.gdb. Create a table test with fields objectid

(Integer),

> userid (Integer), name (Varchar). Then try to add primary key constraint

to the

> first 2 fields:
>
> ALTER TABLE TEST ADD CONSTRAINT PRIMARY KEY PK_TEST
> (OBJECTID, USERINSTID);
>
> Doesn't work. Is this a bug of Firebird SQL?
>
> I had a script that creates a number of tables then adds primary key to

fields. The

> script worked fine. Created tables. But no constraints added to table.
>
> BUG?

USERINSTID and userid are different fields isn't that the problem ?

Regards,
Arno