Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
When to use Transaction Processing and Table Buffering?
Message
From
05/09/2006 04:39:28
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01150834
Message ID:
01150839
Views:
25
>I have a single DBF, where several records need to be updated independent of the rest of the database. However if all records are not updated successfully, then I need to revert the all changes.
>I can achieve this with BEGIN TRANSACTION ... END TRANSACTION or with Table Buffering.

with table buffering you cannot. then ...

>Which alternative is recommended and what is faster?

no alternative.

>Note that ideally, I do not want to lock the table during this process.

this is impossible.
Previous
Reply
Map
View

Click here to load this message in the networking platform