Hi

 

I´ve a problem with transaction my code it´s something like:

 

 

FbTransaction myTrans = Con.BeginTransaction();

 

try

{

FbCommand cm = new FbCommand(“Recibe”,Con);

Cm.Transaction = myTrans;

cm.CommandType = StoredPRocedure; 

cm.ExecuteNonQuery();

myTrans.Commit();

 

}

catch

{

            myTrans.RollBack()

}

 

>From other program (ibexpert) I update the same record that Recibe
procedure, the problem lts that cm.ExecuteNonQuery() wait until fthe other
transaction (ibexpert) finish, why dosen´t raise an exception?. RollBack
never execute.

 

Thanks

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to