table corrupt in vfp 9 but not vfp 6

[eldergeek45]

We have a system compiled in Visual Fox Pro 9.
We get an ocaissional error:

Error#() : 2005
Message(): Error loading file - record number 28 filename.dbf has become corrupted.

We CAN easily repair this by:
...opening the table with VFP 6
...copy to a temp file with cdx
...delete all, pack
...append from temp file

Can anyone explain what is happening?

 

[StewartUK]

I'm confused. Looking at the help, it looks like the error number you quote doesn't match the error message.

The message you quote is to do with opening a form or class, either for editing or when running a form.

Please clarify,

Stewart

 

[TamarGranor]

VFP 9 uses a stricter test for corruption when opening a table, so tables that have minor corruption that open without error in earlier versions might pop an error in 9.

The right answer is to fix the corruption.

Tamar

 

[bborissov]

Check SET TABLEVALIDATE topic in HELP for more explanation of what happens

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP