Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error 108 - record lock issue
Message
From
23/10/2008 18:20:23
Neil Mc Donald
Cencom Systems P/L
The Sun, Australia
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01356720
Message ID:
01356761
Views:
22
Hi,
JAG check out SET TABLEVALIDATE TO n and the "4" additive bit in help.

>We have a labor table in VFP that is written to whenever employees clock-in or clock-out. This works fine, however, we have another VFP app that needs to update a set of these records to indicate that they have been processed (imported into our ERP system). The problem is that if this "import" program is run during lunch time or break time it often causes an Error 108 "File in use by another user". I have tried APPEND and INSERT and both result in this 108 error seeming to have to do with Record buffering/locking, etc.
>
>Does anyone know a way around this? I've tried using the REPROCESS but then it seems to cause the labor entry system to get the error instead of the "import" system.
Regards N Mc Donald
Previous
Reply
Map
View

Click here to load this message in the networking platform