Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error 108 - record lock issue
Message
De
23/10/2008 18:20:23
Neil Mc Donald
Cencom Systems P/L
The Sun, Australie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01356720
Message ID:
01356761
Vues:
23
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform