Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Buffering vs Begin..End Transaction
Message
From
24/12/1999 16:59:07
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00305569
Message ID:
00308455
Views:
25
>>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
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform