|Subject||Re: [ib-support] Post in transaction|
----- Original Message -----
From: "Burak OZLER" <burak.ozler@...>
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"."
> 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