Subject Post in transaction
Author Burak OZLER
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 posted.
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??

Ucuncu Bilgisayar "MagicSoft"
+90 232 464 89 33 Ext:123
"We may not have it all together
But together we have it all "

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