Subject RE: [ib-support] Post in transaction
Author Wilson, Fred
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

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

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]

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to

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