Transactions with VFPoleDB ?


Author
Message
Michel Levy
Michel Levy
StrataFrame User (441 reputation)StrataFrame User (441 reputation)StrataFrame User (441 reputation)StrataFrame User (441 reputation)StrataFrame User (441 reputation)StrataFrame User (441 reputation)StrataFrame User (441 reputation)StrataFrame User (441 reputation)StrataFrame User (441 reputation)
Group: StrataFrame Users
Posts: 193, Visits: 9K
Hi,
  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 Unsure
  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



GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search