>>Correct me if I am wrong, transactions has been around since fox2.x and at that time no such thing as buffering feature. If there is, then there could be a different implementation in VFP.
>
>Transactions were totally new to VFP 3.0.
Jim,
Jess is right there. Transactions are partially new to Foxpro 3.0. Was available in 2.x as Netware.plb functions to support Novell netware. I remember clearly because I've used them then and was happy to see its easier implementation in VFP.
Second transactions in VFP don't need buffering. ie:
close all
open database testdata
set dele on
use customer
begin transaction
? "In transaction :",cursorgetprop("Buffering","customer")
delete for cust_id = "A"
? "In transaction, deleted:",cursorgetprop("Buffering","customer")
insert into customer (cust_id) values ("XXXXX")
? "In transaction, inserted:",cursorgetprop("Buffering","customer")
browse
rollback
browse
Cetin