Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transactions on VFP3.0 tables
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00348536
Message ID:
00348701
Views:
28
Bob,
A Transaction command locks the records that are affected until the END Transaction or ROLLBACK commands are made. You should only use a Transaction command at the time you are saving data. Don't open a transaction until your user has completed editing and your program has done all the required validation. Then open the Transaction, save/update/delete data as required and complete the transaction.

HTH
Barbara

>Hi All,
>
>I am working on an application which uses a VFP 3.0 database as a backend. If I begin a transaction and perform an update on a record in a table, no other user can perform updates on that table. Is this the normal behavior?
>
>Thanks
>
>Bob
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform