Transactions are not supported on free tables.


>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