Thanks...
Now its clearer! :)
Glenn Marintes wrote:
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?
Hi Glenn,
I'm not an expert on this, but a look in the reference manual tells me
that you cannot use CASCADE with ON UPDATE.
REFERENCES table-Name [ ( Simple-column-Name [ , Simple-column-Name ]*
) ]
[ ON DELETE {NO ACTION | RESTRICT | CASCADE | SET NULL}]
[ ON UPDATE {NO ACTION | RESTRICT }]
|
[ ON UPDATE {NO ACTION | RESTRICT }] [ ON DELETE
{NO ACTION | RESTRICT | CASCADE | SET NULL}]
As you can see, only NO ACTION or RESTRICT can be used with ON UPDATE.
Maybe someone can elaborate on why this is so?
Is this a piece of missing functionality in Derby?
--
Kristian
--
*******************************************
*
* Glenn M. Marintes
* Software Development Section
* JANET
*
