>Hello,
>
>I used to have one table which caused me a headache for some records leading to
>the error 'INTERNAL CONSISTENCY ERROR' , please help me what this means this error during the process of one program but it happened randomly.
>
>Thanks
>PP

Paul,

This error can happen when the index is somewhere damaged; a damaged index can cause various problems, up till internal looping or C5.
Once I had this real pain in the neck thing, and it came from some bits fallen over in the compiled program (after sending via PCAnywhere or so). So it could be that recompiling the program can help.
Also look at the index being consistent with the data; not all implied errors can be worked out properly. F.e., what happens when a 9999999999*nField is in there ?
Also (longer strings of) to many duplicate keys in the index will let VFP crash, though normally in a C5.

Internal consistency : VFP recognizes something is wrong, but can't tell what. In may cases this will lead to memory-problems, and in many cases this is implied by wrong client-settings (Novell client etc).

HTH