Hi Ulrich,

first you have to POST every change or insert for each dataset (query,
table) individually. After all work is done, you have to decide between
commit or rollback of the complete transaction (that means all changes since
the last starttransaction!). The TIB_Transaction can't be committed only for
one connected dataset nor is this a useful idea.

Robbi



<ulrich.groffy@...> schrieb im Newsbeitrag
news:00db01c278c3$44130c10$0a00a8c0@p3w2k...

> Hello,
>
> I use two TIB_Query components in master-detail relation with one
> TIB_Transaction. The detail table has a FK with the PK of the master

table.

> Is it possible with only one TIB_Transaction to commit the detail table
> before master table, cause the other way around there is a key vialation
> error.
>
> Best regards - Ulrich