Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Slow file access
Message
 
 
To
08/08/2000 11:39:33
Steve Jones
Business Systems Services Uk Ltd
Swansea, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00402187
Message ID:
00402285
Views:
15
Okay, let's define "procedure". What does this do?

The specification you have below has all the record locking set to the VFP defaults. These are not good in a multi-user environment because the defaults tell VFP to wait indefinitely to get a lock. It is much better to limit this to some set number (or number of seconds - VFP attempts record locking on failures approximately 6X/second) and include error handling if you don't get the lock. This could be slowing your system down.

>
*snip*
>
>VFP Configuration
>--------------------------
>Version: 6.0 part of the Visual studio
>(Locking and buffering settings)
>Automatic file locking is not checked
>Multiple record locking is not checked
>buffering is off
>reprocessing is set to attempt lock (default)
>
>The Program
>-------------------
>The program has built in error and locking routines which use the rlock() function to test for locks. This seems to be working fine.
>
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Reply
Map
View

Click here to load this message in the networking platform