Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Debugging duplicate sequental keys on the network...
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Debugging duplicate sequental keys on the network...
Divers
Thread ID:
00158926
Message ID:
00158926
Vues:
47
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
Répondre
Fil
Voir

Click here to load this message in the networking platform