Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Losing data - serious problem
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00554460
Message ID:
00721584
Views:
11
Maybe you could change your append/seek/go/replace/etc syntax to use the more multi-user-friendly, like using SQL-Select and SQL-Update.

Maybe you could take when your desktops are inputting and have them first input it locally on their system, and then copy the DBF to the central system where a single EXE on the server does the actual data updating.

Also, why are you using row buffering instead of table buffering? It seems like row-buffering requires much more impact on the DBF header than table buffering.

>Hi,
>I have a VFP 6.0 laboratory system for grain samples. Tha lab is collecting data about weight, water%, protein etc. It is quite simple with one main DBF. This DBF is FOX2x as I need to read data from another program. There are 10 PCs adding record and updating the file. The volume is about 1500 new samples every day added from 2 of the machines and 3-5 updates on these records from the other PCs. Input is mainly from bar-codes and online weights.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform