Hi everybody,
We ran Referential integrity builder without PACK Database first and got Internal consistency error. In VFP8 it would mean that database is corrupted beyond repair. However, we tried to open it with validate option, then packed it and re-ran RI builder and everything went smooth.
Also I have a question. We had VFP8. We installed VFP9. VFP still used Builder.dbf from VFP8 directory and running VFPClean didn't fix the problem. Only after re-naming this table VFP prompts for the Builder definition table. I also had to recompile RIBuilder and SFRIBuilder to make it work in VFP9.
If it's not broken, fix it until it is.
My Blog