Subject | FW: Cascade |
---|---|
Author | Dion |
Post date | 2002-01-14T13:26:57Z |
-----Original Message-----
From: Dion [mailto:dion@...]
Sent: Monday, January 14, 2002 1:35 PM
To: 'IBObjects@yahoogroups.com'
Subject: Cascade
Hi,
I have the following constraint declared:-
ALTER TABLE "COVEREDMEM" ADD FOREIGN KEY ("MEMBERID") REFERENCES MEMBER
("MEMBERID") ON UPDATE CASCADE;
When I edit and post on the MEMBER table, I get an integrity error. Are
there other settings which need to be made on the TIB_Query object(ie do I
have to set an EditSQL value?).
Thanks,
Dion
From: Dion [mailto:dion@...]
Sent: Monday, January 14, 2002 1:35 PM
To: 'IBObjects@yahoogroups.com'
Subject: Cascade
Hi,
I have the following constraint declared:-
ALTER TABLE "COVEREDMEM" ADD FOREIGN KEY ("MEMBERID") REFERENCES MEMBER
("MEMBERID") ON UPDATE CASCADE;
When I edit and post on the MEMBER table, I get an integrity error. Are
there other settings which need to be made on the TIB_Query object(ie do I
have to set an EditSQL value?).
Thanks,
Dion