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?


__________________________________________________
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/