Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Time Response
Message
From
15/05/2002 18:06:49
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
15/05/2002 14:13:01
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00655894
Message ID:
00657183
Views:
25
It takes lots of users, but eventually yes. Every view record is locked each time a user runs a query. It seems though that the lock is held while the query string itself is extracted, not for the duration of running the query itself.

>Great idea... I'm going to give it a try...
>
>Nope, my old app did not use a DBC. Multiple users accessing DBC slows it down?
>
>>SQL Server can be better, but I don't think it necessary here. You create your table tabledbc.DBC and store it on the server.
>>
>>The views.DBC contains views like this...
>>
>>create sql view someview as ;
>>select field1, field2 ;
>>from ;
>>tabledbc!table1
>>
>>etc.
>>
>>Your old app didn't use a DBC right?
>>
>>>snipped<<
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform