Hi,

Please regard the following code snippet, from my app:


FbTransaction trans = cmdData.Connection.BeginTransaction();
try
{
   cmdData.Transaction = trans;  // (1)
   cmdÄgare.Transaction = trans; // (2)
   cmdIdn.Transaction = trans;   // (3)
...
}

When executing this, cmdData.Transaction becomes == trans after 
executing (1) as expected.

But when executing (2), cmdData.Transaction becomes == null again, while 
cmdÄgare.Transaction becomes == trans.

Then, again, when executing (3) cmdÄgare.Transaction becomes == null and 
cmdIdn.Transaction becomes == trans.

At this stage, if I use the VS 2008 debugger to set (1) as next 
statement, and re-execute (1)-(3), everything works as originally 
expected, and all .Transaction == trans.

I haven't done ANYTHING unusual with these FbCommands, I just create 
then from th connection object, assign CommandText and add parameters, 
then prepare them. Then the above snippet executes.

After re-executing (1)-(3) to get all Transaction properties set to 
trans and committing the transaction, all subsequent executions of the 
code work fine.

So, what might be going on here?

Kjell
-- 
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kj...@datadia.se
Telefon: 08-761 06 55
Mobil: 0733-44 24 64


------------------------------------------------------------------------------
uberSVN's rich system and user administration capabilities and model 
configuration take the hassle out of deploying and managing Subversion and 
the tools developers use with it. Learn more about uberSVN and get a free 
download at:  http://p.sf.net/sfu/wandisco-dev2dev
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to