Hello,

I use the components of Doa Versions 4.0.3. I have three tables in a master-detail relationship. The first table tab1 is master of table tab2. tab2 is additional master of tab3. After I insert in all three table a record like this

tab1.insert;
tab2.insert;
tab3.insert;

and I just try to post the changes on tab1 like this

if tab1.State in [dsInsert, dsEdit] then tab1.post;

then I`ll get the ORA-02291 error, cause doa try to post first the changes of tab3. What is the reason? I`ll set the property CommitOnPost to false. Could anyone give me a solution? Thanks in advance.

I can't imagine why this would happen. Do you have any event handlers on the tab1 dataset that could cause this?

I only declared AfterInsert-events for all three tables to set default values of not null columns.

What happens if you remove these events?

The same.

The CommitOnPost property should not be a factor. Committing allows your updates to be visible to others in the database. All your issue at this point remain local to your session.

What Primary Keys are propogating from Master to Detail to join the tables together? Are they values from sequences?

The first and second table have respectively two PKs - one of them with a sequence. The third table has two PKs without a sequence.

Isn`t anybody out there? My problem still exists but I don`t get any response since one month.