1. 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
2. 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

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

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

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

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.

I can't believe that you have no idea

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, ??).