Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Debugging duplicate sequental keys on the network...
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Debugging duplicate sequental keys on the network...
Miscellaneous
Thread ID:
00158926
Message ID:
00158926
Views:
46
Hi All,

I am trying to find the reason for getting the duplicate numeric sequental keys in FP DOS 2.5 networking app, running under Windows 95 + NT Server 4.0. There used common approach with system lookup table with next available key - you know:
RLOCK(), increment, REPLACE, UNLOCK, return the key.
The system table is closed after each REPLACE.
But it still generate duplicate keys. And the running the tests say, for total 300,000 records created from 2-3 workstations show no duplicates.
I searched UT for this subject and know that there may be a problem with the buffers on NT Server, or Windows may not tell FP the real truth about locked/unlocked records :). BTW, after the NT server was moved from the next room to another building the number of duplicates was greatly reduced.
I am going to try to disable NT Server write cache, but it can cause other problems.

Does anybody have extra info, experiences or ideas on this subject?
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Reply
Map
View

Click here to load this message in the networking platform