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.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao