StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Transactions with VFPoleDB ?

RE: Transactions with VFPoleDB ?

Michel Levy — Wed, 11 Apr 2012 09:53:32 GMT

Bump.... No ideas, nobody??

Transactions with VFPoleDB ?

Michel Levy — Wed, 11 Apr 2012 09:53:32 GMT

Hi,

Wich IsolationLevel should I choose when I begin a transaction? ReadCommitted seems to run fine, and also Unspecified...
I know which one to choose in SQL according to my needs, I use transactions in VFP code for many years without thinking of the IsolationLevel, and now, I'm lost :unsure:

Having this code:

       TransactionBegin("DataVFP","Tnx1",Data.IsolationLevel.Unspecified)
       If  Me.BO_Northwind_Employee.Save(True,"Tnx1")=MicroFour.StrataFrame.Data.SaveUndoResult.Success 
            TransactionCommit("DataVFP","Tnx1")

In the html trace - MicroFour.StrataFrame.Data.DataBasics.DataSources("DataVFP").SetDebugOn(...) - I read

Transaction:

False

I expected True...

So I wonder how transactions are really supported by vfpoledb

RE: Transactions with VFPoleDB ?

Michel Levy — Sat, 28 Aug 2010 17:29:34 GMT

Ivan,

I can't believe that you have no idea :doze:

nothing on the UT, nothing on Foxite, nothing on MSDN forums... I hope that a VFP guru here would know (Charles, Edhy, Marcia, Toni, Greg, ??).

RE: Transactions with VFPoleDB ?

Ivan George Borges — Sat, 28 Aug 2010 14:02:26 GMT

Hi Michel.

Sorry for not being able to give you any exact answer on this, I simply have no idea. :D

I also tried on the Universal Thread, where there should be loads of VFP gurus, searched it all and couldn't find anything about Transactions on the VFPOleDB. I will see if I can get something more substantial to you, but I guess the VFPOleDB provider might not help a lot on this. I have suffered quite a bit with it to build my Import methods to get the data out of the VFP legacy tables and into SQL Server, and that was just a plain reading procedure.

RE: Transactions with VFPoleDB ?

Michel Levy — Sat, 28 Aug 2010 12:20:46 GMT

Hi Ivan,

thanks for that links.

1st one does not give me more information : when Anders writes "... should work as well..", it's exactly what I need to be definitely sure, without any doubt.
from 2nd link, I jump to http://msdn.microsoft.com/en-us/library/ms917355.aspx where I've found some interresting informations.

but what about the html trace where one can read Transaction:False, even if I have a TransactionBegin...? is it a true information (so, it means that I have failed when establishing the transaction, but I had no error), or is that information not updated on a vfp transaction? Could you please ask our SF gurus?

And how do you understand the way VFP manage its transactions? which isolation level does it use? ReadCommitted?

Thanks a lot for your help

RE: Transactions with VFPoleDB ?

Ivan George Borges — Sat, 28 Aug 2010 11:20:49 GMT

Hi Michel.

Some posts I found on the subject:

http://www.dbmonster.com/Uwe/Forum.aspx/foxpro-queries-sql/268/Rolback-Transaction-fails-for-OleDb-Provider-8-for-Visual

http://social.msdn.microsoft.com/Forums/en-US/visualfoxprogeneral/thread/1bf72b30-0603-4d3f-a40a-ae29720c9e61#1bf72b30-0603-4d3f-a40a-ae29720c9e61