Hi,
I am a student at the University of Alberta, Canada and came across your
support page while looking for some reference on 'ON UPDATE CASCADE'.The
problem that I am facing is with the following statement,
CREATE TABLE BLAH(
blah1 VARCHAR(80) PRIMARY KEY,
blah2 INT REFERENCES ANOTHER_BLAH(blah)
ON DELETE SET NULL
ON UPDATE CASCADE);
I can enter the "ON DELETE CASCADE" OR "ON DELETE SET NULL", without any
problems, but when I add "ON UPDATE CASCADE" on the next line, after one
of the above, I get error messages, telling me that I am missing a right
bracket. I am not missing a right bracket anywhere, and things work just
fine when I take out the "ON UPDATE CASCADE" part.
So I'm a bit perplexed as to what is wrong with ON UPDATE CASCADE ?
I tried to find out more in the manual but didn't have much luck.
Thanks in advance for your help,
Vishal
