Why are you using two transactions ??
Are you using two threads ??
If it's the same thread (or a single threaded program), you don't need to
start another transaction.


Best regards,
Fred Wilson
SE, Böwe Bell & Howell
fred.wilson@...



-----Original Message-----
From: Burak OZLER [mailto:burak.ozler@...]
Sent: Wednesday, February 19, 2003 7:02 AM
To: ib-support@yahoogroups.com
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 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"."
error.

how can I achive to post the BB before committing transaction1??

I hope I could explain the stuation??

--------------------------------
Burak OZLER
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]



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



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