Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Locking SQL database while updating
Message
From
09/03/2001 15:23:17
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Locking SQL database while updating
Miscellaneous
Thread ID:
00483661
Message ID:
00483661
Views:
46
Hi all,

I'm working on an app that using SQL as back-end database. I created several updatable views in FoxPro. For each transaction, my app updates several tables in SQL (updating views). Before I start updating, I try to lock all of the tables (file locking) that my app is going to update. I can do it very easy if the back-end database is VFP. I don't know how to do it if the back-end database is SQL. Please help.
Thanks in advance.

PhuTri
Next
Reply
Map
View

Click here to load this message in the networking platform