Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FLOCK() causes duplicate primary keys.
Message
From
29/08/2005 20:32:14
Neil Mc Donald
Cencom Systems P/L
The Sun, Australia
 
 
To
29/08/2005 09:31:48
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows Server 2003
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01043971
Message ID:
01044986
Views:
15
Hi,
Try these
http://www.superbase.com/services_tech_support_net_fact_sheet.htm
http://www.dataaccess.com/whitepapers/opportunlockingreadcaching.html

>>Hi,
>>
>><snip>How to disable disk caching ?
>>
>>The flush should fix the problem.
>>
>>To disable write caching, it has to be done on both the workstation and server in Control Panel/System/Hardware/Device Manager, Right click on the hard drive & select properties then under the policies tab uncheck the Enable write caching on disk, save then reboot.
>>
>>>> P.S. On a highly loaded system I have seen the OS drop a dirty cache without ensuring that it was written back to disk.
>>>
>>>I do'nt believe this.
>>
>>Have you ever had the error message "Edits were lost" in WORD, this is when it happens.
>>
>>This is well documented by many DB providers i.e. MYSQL, DataFlex etc, and I have confirmed it during testing.
>>
>>BTW a system can work perfectly for 12 Months, then you add one or two additional workstations then the problems start.
>
>Neil,
>can you provide some link where this problem is describred ?
Regards N Mc Donald
Previous
Reply
Map
View

Click here to load this message in the networking platform