Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Corrupted File?
Message
From
28/01/2008 07:14:35
Guy Pardoe
Pardoe Development Corporation
Peterborough, New Hampshire, United States
 
 
To
27/01/2008 14:49:34
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
01285906
Message ID:
01286016
Views:
23
Hi Jim,

In the past few years I've only seen three causes of VFP data corruption personally.

1) bad shutdown (power outage and UPS battery failed)
2) bad network card or switch
3) write cache turned on for server hard drives

Guy




>Naomi --
>
>Both reasonable suggestions, which I will try ...
>
>Is what is going wrong here some failure when two people try to insert at the same time? No automatic file locking? (Just trying to understand the root cause).
>
>Thanks,
>
>Jim
>
>
>>>I have an event history file which evidently can get corrupted.
>>>
>>>The only time the file is written to is by this code
>>>
Select 0
>>>Use (fname) Alias EventHistory Shared
>>>
>>>Insert Into EventHistory (When, who, pgmname, exename, desc1, desc2) ;
>>>	VALUES (MountainTime(),goVars.UserName, goVars.ApplicationName, Juststem(Sys(16,3));
>>>	, lcText1, lcText2)
>>>Use
>>>
>>>
>>>Do I need to put some locking around this, and, if so, what would the code look like?
>>>
>>>Thanks
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform