>>Hi everybody,
>>
>>If I do not do PACK Database and COMPILE Database before trying to re-build the RI, I'm getting the error "Internal Database consistency error".
>>
>>I tried to avoid it with the following code:
>>local oError as exception
>>try
>> wait window "Compiling database..." nowait noclear
>> compile database (dbc())
>>catch to oError when .t.
>> wait window "Error, rolling back changes..." nowait noclear
>>
>> =messagebox("Error making changes in RI!"+chr(13)+;
>> oError.message+chr(13)+;
>> "Error #:"+transform(oError.ErrorNo)+chr(13)+;
>> "Line #:"+transform(oError.lineno)+chr(13)+;
>> "Error #:"+transform(oError.LineContents),48,"Error")
>>finally
>> wait clear
>>endtry
>>
>>if m.lcOldSafety = "ON"
>> set safety on
>>else
>> set safety off
>>endif
>>release thisform
>>
>>But I still have the same error. Using VFP8. So, my question is: can we trap this error? And how can we prevent it?
>>
>>Thanks.
>
>Nadya,
>
>Don't know whether that has in vfp8 but in vfp6 you had to
>
>(1) Clean up database before building the RI ( = PACK DATABASE)
>
>(2) after having added/overwritten the code in the database (with append procedures) you had to COMPILE DATABASE
>
>
>These are the operations you have to do.
>
>The only exception to catch is OPEN DATA ... EXCL for the pack
I added the code for PACK and COMPILE in the builder itself, but it didn't help. The error is still occurring. By this I deduct, that this error is untrappable.
If it's not broken, fix it until it is.
My Blog