Hi,

I am a new subscriber to Universal Thread, hoping to get some advice as to a problem that I am having that I suspect is a caching problem.

I have been running an application in Foxpro for over 10 years; started in 2.5, now rewritten and running in 6.0. I have had about a dozen instances of this happening over the years and am stumped.

First, the server crashes with a data file open (Win 2k server with UPS). (Why the server crashes is another problem which I am working dilegently to fix.) However, after restarting I find corrupted records (last time 8 corrupted records were found in my primary file). I delete these records, pack the file, and an entire day's worth of records disappears.

Additionally, I found that updates to previously created records become reverted back to their original state. In an associated, child file, the records appended during the day remained, but the memo field were blanked.

Not all files were reverted or corrupted, however. Other programs running in VFP 5 (my accounting system, for example) have survived intact.

I do have a FLUSH command run after every new record is added to the main file. I do understand that an enhanced flush command is available in VFP9, but I am not eager to update based on my current understanding of the problem.

The server has a RAID drive set, using an Adaptec controller. The workstations are all XP, SP2. The network wiring is CAT 5 and the switches are on a UPS, also. I suspect that it is a caching problem, but I find it hard to believe that an entire day's records would remain in cache for more than 12 hours.

Any help would be appreciated.

Thanks,
Howard