--- In firebird-support@yahoogroups.com, Steven Gibb <stevenggibb@...>
wrote:

>
>
> It is a simple table:
>
> CREATE TABLE PROGRESSREPORTSUBMISSION (
> ID INTEGER NOT NULL,
> RECORDSOURCE CHAR (1) CHARACTER SET NONE NOT NULL COLLATE NONE);
>
> /* Primary keys definition */
>
> ALTER TABLE PROGRESSREPORTSUBMISSION ADD PRIMARY KEY (ID, RECORDSOURCE);
>
> I get the error with : SELECT id from progressreportsubmission
>

the ALTER TABLE sentence should read

ALTER TABLE PROGRESSREPORTSUBMISSION ADD CONSTRAINT CONSTRAINT_NAME
PRIMARY KEY (ID, RECORDSOURCE);

Maybe that is the source of the problem.

Best regards,

Guillem