|Subject||Re: [IBO] Cascade|
> I have the following constraint declared:-What error do you get?
> 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?).
If the error occurs after an edit, it sounds like you are altering the
primary key (MEMBERID) on the main dataset and so causing a cascaded
update. You can avoid such overheads by using surrogate (generated)
key values on tables so that they never need to be updated.
Run the IB_Monitor to see what is actually happening when you post the
changes and then check the triggers etc on your tables to ensure that
there are no side-effects which may be causing the problem.
Geoff Worboys - TeamIBO