db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Glenn Marintes <gl...@janet.co.jp>
Subject Derby foreign key ON UPDATE clause problem
Date Thu, 06 Apr 2006 06:46:23 GMT
Hi All,

ij> CREATE TABLE Seal ( sealId BIGINT NOT NULL, sealFilename 
VARCHAR(512), sealCode VARCHAR(64) NOT NULL, sealName VARCHAR(256) NOT 
NULL, sealGroupFK BIGINT NOT NULL, PRIMARY KEY(sealId), FOREIGN KEY 
(sealGroupFK) REFERENCES SealGroup (sealGroupId) ON UPDATE CASCADE );
ERROR 42X01: Syntax error: Encountered "CASCADE" at line 1, column 256.


What does this error mean? How do we correct it?

-- 
*******************************************
*
* Glenn M. Marintes
* Software Development Section
* JANET
* 


Mime
View raw message