Does the VFP8 OleDb Driver support transactions? I'm doing UPDATEs and INSERTs against several free DBFs in VB.NET using the VFP8 OleDb driver. I'm using a System.Data.OleDb.OleDbTransaction object to wrap several UPDATEs and INSERTS in a transaction. If I roll the transaction back in the middle, the UPDATEs and INSERTS done so far are actually comitted. They don't get rolled back.
Could I be doing something wrong, or does the VFP8 OleDb Driver just not support transactions (or at least not for free DBFs)?
-----
Lee Perkins
-----
Lee Perkins
TigerBase Technologies
"Lee is one that would plug his brain into the internet, if he could, and STILL scream for more" - Very good friend of Lee's