Hi,

Firstly, this could very well be an index problem. But I guess you already reindexed.

Secondly, once I encountered such a situation after the FPX was sent via a modem line to a customer. Some bits seem to have fallen over, and a re-send of the program fixed the problem.

The inconsistency error is usually about memory problems, OR index problems.

HTH,
Peter


>I'm using VFP 6.0. I am having trouble running a piece of code (either in native mode or executable format) when I receive the error message 'Internal Consistency Error' before getting blown out of VFP.
>
>There are a few odd things occurring. First, I can run the same code against different files and it works fine (which leads me to believe it's a data issue - so I've view the tables to see if I see any odd characters or corruption and found nothing). Second, if I manually enter the commands from the command window, it works fine. Third, this same command is used throughout this program (with modifications to the criteria) and works fine. Fourth, the identical piece of code works in FoxPro 2.6, which is currently being used in production.
>
>To explain in more detail, I'm locating a record in one file and trying to find the matching piece in another file. The second file has an index set with filtering criteria so with the order set only 2 records are displayed (usually much higher). At any rate, if these records match from the respective files, I'm assigning a unique number to each file. This is done with the following command (which is where I receive the error):
>
>REPLACE matchnum WITH STUFF('CM23000000',11-LEN(LTRIM(STR(varnum))),;
> LEN(LTRIM(STR(varnum))),LTRIM(SUBSTR(STR(varnum),6,5)))
>
>Also, the varnum variable is initialized to 1 prior to executing this command. Lastly, the command is actually executed (meaning the field in question is replaced) but I never get to advance to the next line of code when stepping through it.
>
>Thank you in advance for any suggestions.
>
>-Missy