>I want to move an application from version 7 to version 9. I have already updated other projects without any problem. When I try to use the update with the customers data it complains that several (but not all) tables are corrupt. Checking the tables in v 7 shows no problems. I am reluctant to do too much by way way of validating etc in v9 in case I end up with it not working in both versions! Any thoughts
>TIA
>Michael
Your client has a problem with data corruption, and unless he enjoys sitting on an armed bomb, he needs to fix this as soon as possible. VFP9 can detect some errors in the tables before the errors cause a total data crash, VFP7 does not see these errors, and in stead you will eventually lose data. To fix that in VFP9:
lnTablevalidate = set('tablevalidate')
lcSafety=set('safety')
set safety off
set tablevalidate to 0
Use yourtable exclusive
copy to temp
zap
append from temp
set tablevalidate to lnTablevalidate
if lcSafety='ON'
set safety on
endif