Hi,

When I am trying to create the table in firebird database using the
following Script I a getting "Key size too big RDB$PRIMARY8" Exception.


CREATE TABLE TABLE2 (

FIELD1 VARCHAR(40) NOT NULL,

FIELD2 VARCHAR(40) NOT NULL,

FIELD3 VARCHAR(40),

PRIMARY KEY(FIELD1, FIELD2), FOREIGN KEY(FIELD1)

REFERENCES TABLE1(FIELD1) ON DELETE CASCADE);



where FIELD1 is the primary key in the table TABLE2 and its maximum
length is 40 characters.

Can anyone specify me the reason for getting this error.






Thanks n Regards,
=============================
Rambabu Piridi.



[Non-text portions of this message have been removed]