>>>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.
Strange. My memory is not what it used to be, sigh
Gregory