Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
AutoInc has given me a duplicate!!!
Message
From
03/11/2010 18:16:10
Neil Mc Donald
Cencom Systems P/L
The Sun, Australia
 
 
To
03/11/2010 16:34:38
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01488078
Message ID:
01488105
Views:
62
If caching and oplocks are on and the redirector fails it can happen, same as the desciption of the SMB2 fix that is currently being tested.
In a nutshell the local cache has'nt been updated with what has happened on the disk, you will get a duplicate.

>I have never seend this happen before, but it appears that one of my tables where I use an AutoInc field (that I use as a primary key), has given me a duplicate value to 2 records.
>
>Is this possible?
Regards N Mc Donald
Previous
Reply
Map
View

Click here to load this message in the networking platform