Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
.DBC for views
Message
From
12/06/2001 16:33:17
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
.DBC for views
Miscellaneous
Thread ID:
00518600
Message ID:
00518600
Views:
49
Hi all

According to page 159 of Certfox, a .DBC record is locked when a view is requeried AND this lock prevents others from doing a query until the results are returned. If that's true, it should be demonstrable with only 2 users and a query against a large table returning lots of records.

So, I tried it. Query progress bars were active on both machines, but if I interpret CertFox correctly, one machine should have had to wait.

It should be possible to show record contention with 2 users. Anyone have any code that could demonstrate this?
Next
Reply
Map
View

Click here to load this message in the networking platform