Subject Re: [IBO] TIB_Transaction in master detail
Author Jason Wharton
This isn't an issue of Commit, but rather posting order. You can PostRetain
the master dataset so that it will remain in insert state and allow the
detail to Post its insert. Behind the scenes IBO does an insert on the
server for the master dataset and then when it actually does its post it
will update the record. I think of it as allowing the master to do a stub
insert and then when it is done it will complete the insert by updating the
stub record with its final values. If the insert of the master is cancelled
then the stub record is deleted.

Jason Wharton
CPS - Mesa AZ

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: <ulrich.groffy@...>
To: "IBObjects Newsgroup" <>
Sent: Sunday, October 20, 2002 10:32 PM
Subject: [IBO] TIB_Transaction in master detail

> 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
> 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