Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Any reason to buffer local views?
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00458169
Message ID:
00458368
Views:
18
>>>There is a problem with views though, in that the view record in the DBC is temporary locked when the view is opened. If two users are opening the view at the same time, one may fail. So many developers put their views in a separate DBC, and keep that DBC on the local machine. So there is one DBC on the server for the tables, and each user has their own copy of the view DBC.
>>
>>Is this only when the view is opened - not requeried?
>>
>
>I don't believe so because the view structure is already known and getting that information from the DBC is not necessary.

Did you mean to say, "I believe so"? Thereby answering his question as -- Yes the record is only locked when the view is opened and not when requeried.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform