Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View updates when closed
Message
From
19/05/2004 14:49:33
Todd Cottengim
Alpine Land Information Services
Redding, California, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
View updates when closed
Miscellaneous
Thread ID:
00905372
Message ID:
00905372
Views:
62
This problem has arrisen after an upgrade to VFP8-SP1. The underlying code worked fine in VFP6-SP5

An application uses local views to display selected data in a form, with multiple users accessing the data (each with his/her own view). When User 1 edits a record in the view, the corresponding record is locked in the table (the client wanted this type of pessimitic locking). If User 2 tries to exit the application while User 1 has a record locked, we get a "Record not locked" message. It appears as though User 2's view is updating itself to the table when the following is executed: USE IN SELECT (View name here)

IS this a new "feature" in VFP8?

Thank you

Todd Cottengim
Reply
Map
View

Click here to load this message in the networking platform