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
*