using VFP 9 to reindex FP 2.6 tables

[agbtech]

Does anyone have any specifics about problems caused by reindexing FoxPro 2.6 tables in VFP 9?
We are about to migrate and have a reindexing program written in VFP 9 but the app is still at the moment in FPW 2.6.

 

[r0gerc]

I think FPW2.6 DBFs are OK as long as you don't put them in a VFP DBC or try to modify the structure in VFP. Then they will become VFP DBFs which are a slightly different format. The safest thing is to copy one of the 2.6 files to another folder, re-index it with VFP then try to open it again in 2.6 and see what happens.

Roger

 

[DSummZZZ]

It is perfectly safe to reindex 2.x files using VFP. We do it on a regular basis.

But like Roger said, if you modify the structure of the .dbf using VFP, they will no longer be usable by 2.x.


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[brigmar]

But like Roger said, if you modify the structure of the .dbf using VFP, they will no longer be usable by 2.x.

This isn't entirely accurate.

VFP can be used to modify the structure (with both ALTER TABLE and MODIFY STRUCTURE), just so long as you don't add any non-2.x datatype fields.

 

[agbtech]

When I set an index on a FP 2.6 table from within VFP and the index is a date field, I get an internal consistency error when I try to append a record. I have to create the index on a temporary file created from a copy of the original and then copy the temp file back with cdx type fox2x. It works fine then.