Subject Re: [ib-support] Post in transaction
Author Burak OZLER
I need the second Transaction becouse of data security.
I start a transaction then I run lots of procedures in an other transaction if procedures works well then I commit trn2 then trn first.

----- Original Message -----
From: benno
Sent: Wednesday, February 19, 2003 4:11 PM
Subject: Re: [ib-support] Post in transaction


----- Original Message -----
From: "Burak OZLER" <burak.ozler@...>
To: <>
Sent: Wednesday, February 19, 2003 3:02 PM
Subject: [ib-support] Post in transaction

> Hi all,
> I have a problem that must have solved very urgently.
> 1 - I start a transaction1
> 2 - Edit AA
> 3 - Change a value at table AA
> 4 - Post AA
> 5 - Start transaction2
> 5 - Change or insert a record to an another table (BB), one field at BB
references a field at AA
> 6 - The referenced value at BB is the row at AA that was edited and
> 7 - When I try to post the data at BB I get an
> "lock conflict on no wait transaction
> violation of FOREIGN KEY constrait "FK_XXX" on table "BB"."
> error.
> how can I achive to post the BB before committing transaction1??
> I hope I could explain the stuation??

I think you can do this by doing both in Transaction 1. Why do you need 2


To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to

Virus taramasi yapildi. Scanned for Viruses. [19/02/2003 - 16:14]

[Non-text portions of this message have been removed]