Re: Corrupted files fpd2.5; vfp9 sp1



It was common in FPD to directly edit the tables. With VFP, you can buffer the data, which greatly reduces the probability of corruption. You need to make sure you've rearchitected your application to use buffering when moving to VFP.

--

Craig Berntson
Microsoft MVP

-------------
"George Smith" <grsassociates@xxxxxxxxx> wrote in message news:65298c40-67a6-4122-a208-53cee2e1afd0@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have an application written in fpd2.5 that is being converted to
vfp. Most users are in fact on the new version, but a handful don't
yet have hardware that supports windows.

The fpd version always suffered from sporadic file corruption. That
was something we are looking forward to getting rid of. We have had
occasional corrupted files during the conversion that I always
attributed to the old version. However, they are increasing in
frequency, and I am starting to doubt my hypotheses. What the user
sees is missing data. That is always corrected by rebuilding index
files.

However, the vfp app generates an error log (for fatal errors only)
and what I see there starting back in Oct 08 is:

Fatal error 2091 has occured in WI_ACCEPT at line 62
Table 'J:\APPS\FOXPRO25\wsa_prod\dbfs\cweightr.DBF' has become
corrupted. The table will need to be repaired before using again.

The errors reflect various files and programs, and happen (more
recently) every few days or so. All of the errors I have checked are
lines that are simply USEing the file. These errors end the program
for the user that got it, but they don't bother anyone else. And if
the user restarts, there are no (obvious) issues.

Of course, I am now thinking this is the source of the blown index
files.

Any thoughts??

.



Relevant Pages

  • Re: Rebuild DBC
    ... Make sure you have the most recent SP for your version of VFP. ... Possible Causes of Data Corruption in Visual FoxPro ... rather then reindexing the tables all the time. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: FPW 2.6 tables and VFP 8
    ... This not being a network / hardware person, ... My index corruption is very specific to one table. ... I have inherited a 2.6 program that I am migrating over to VFP 8. ... This advice inspite that we sell the repair utility. ...
    (microsoft.public.fox.programmer.exchange)
  • RE: Corrupted files fpd2.5; vfp9 sp1
    ... using the Set TableValidate command to a lower level - see VFP Help for this. ... The fpd version always suffered from sporadic file corruption. ... That is always corrected by rebuilding index ... the vfp app generates an error log (for fatal errors only) ...
    (microsoft.public.fox.programmer.exchange)
  • Corrupted files fpd2.5; vfp9 sp1
    ... The fpd version always suffered from sporadic file corruption. ... occasional corrupted files during the conversion that I always ... the vfp app generates an error log (for fatal errors only) ...
    (microsoft.public.fox.programmer.exchange)
  • Re: How to solve a fatal exception error in VFP9SP1 application?
    ... both of you that it is a memory corruption issue which caused the dll ... VFP dlls depends on. ... You have a memory corruption issue. ... I want to know how to read the calling stack which shows ...
    (microsoft.public.fox.helpwanted)