Visual FoxPro 6.0 crashes with APPEND BLANK together with Fox 2.6

[filibuster]

Hi,

we are runnung a colorful mixture of Fox 2.6 and Visual FoxPro 6.0. The problem with this cross plattform occurs when Visual FoxPro appends a record to a (shared) table.

APPEND BLANK

creates an "Internal inconsistency error", Visual FoxPro shuts down instantly, and damages the index files - Only a reorganization will help.

Note:
After crashing, VFP still has the table header locked, so that the table will only be accessible (write) after rebooting the workstation.

Any ideas ?

Thanks
Holger

 

[fluteplr]

Does this happen all the time or only on one specific table?

If one table have you tried reindexing it. Note: reindex from 2.6, reindexing 2.6 tables from VFP can cause some wierd results)

Do you have any indexes that would result in variable length results such as alltrim(somefield) if so get rid of them and replace them with something that always results in the same length.

Also consider using VFP local views with optimistic table locking to update your 2.6 tables, I do this in several applications to deal with legacy 2.6 tables and it works great.