General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
View updates when closed
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only