CachedUpdates on cascade delete

[cazanvova]

Helo! sory my english!
PLEASE HELP ME!!!
have3 table tbl1(CachedUpdates=true) , tbl2(CachedUpdates=true) , tbl3(CachedUpdates=true)

field tbl1: id,a
field tbl2: id,id1,b
field tbl3: id1,id2,c

relation
tbl1.id -> tbl2.id
tbl2.id1 -> tbl3.id1

id,id1,id2: triger
(CachedUpdates=true)
on button OK do ApplyUpdates and ComitUpdates (for tbl1,tbl2,tbl3).but if delete record from tbl2 and after that do ApplyUpdates, - have

SQL Error: violation of FOREIGN KEY constraint "TBL2_TBL3_FK" on table "TBL3" Foreign key reference target does not exist. Error Code: -530. violation of FOREIGN KEY constraint "" The SQL: INSERT INTO TBL3 (ID1,ID2,C) VALUES (?,?,?);

use firebird 2.0 Zeos 6.6.3!!!

[seawolf]

This problem is not related to Zeos, but how you db was structured.

I mean if TBL3.id1 depends on TBL2.id1 it is obvious that if you delete a row TBL2.id1 you have to delete the corrisponding row TBL3.id1.

So you can do:
- delete row TBL3.id1 before deleting row TBL2.id1 separately
or
- do a stored procedure where you delete both rows

[mdaems]

Or you could add an on cascade rule to yor foreign key

Code: Select all

ALTER TABLE INVOICE_SCHEDULE_DATES ADD
FOREIGN KEY (INV_SCHED_ID) REFERENCES INVOICE_SCHEDULE
(INV_SCHED_ID)
ON DELETE CASCADE
ON UPDATE CASCADE;

Mark