Subject Re: [IBO] Transaction with master-child relationship
Author James Chua
Alfred Seetoh wrote:

> Hi,
> I encounter a *scratch-head* reaction with my master-child
> relationship transaction. My master and child tables are CUSTOMER and
> ADDRESS respectively. I've set their relationship according to the
> TransactionsHandling tutorial lesson 2.
>
> Info on child IB_Query:
> MasterLinks: ADDRESS.ID=CUSTOMER.CUST_ID
> MasterSource: DSCustomer
>
> Both IB_Query are using DMMain.TransactionMain as the IB_Transaction.
>
> In my form, I display a single customer and multiple addresses (in a
> TIB_Grid). I have an 'Ok' button that does the following code when
> clicked:
> DMMain.TransactionMain.Commit;
>
> If I update the master information, and click Ok, it works fine.
> However if I update the child information, no matter how many times I
> click the Ok button, it just won't commit;
>
> I then dropped a TIB_TransactionBar component into the form. Then
> update the child info, click the Commit button of the
> TIB_TransactionBar, and it works.
>
> Anybody can tell me what am I missing here?
>
> I'm using Delphi 6, FireBird 1.5 RC7, IBO 4.3A, Win2k.
>
> Thanks
> Alfred
>
Hi there. Could you give the complete setup of your master - child? does
your child ib_query.ib_transaction set to dmmain.transaction? Did you
have child.post before the dmmain.transaction.commit?

James

>
>
> *Yahoo! Groups Sponsor*
> ADVERTISEMENT
> <http://rd.yahoo.com/SIG=12ckdel68/M=267637.4116732.5333197.1261774/D=egroupweb/S=1705007183:HM/EXP=1070953426/A=1853619/R=0/*http://www.netflix.com/Default?mqso=60178356&partid=4116732>
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/>.