>>Hi all, I am getting the following error on an END TRANSACTION. This did not occur in our app until we upgraded from VFP 6 to VFP 9.
>>
>>Error: Table "C:\DOCUME~1\michaelv\LOCALS~1\Temp\00006Y2X001I.TMP" has a file length / record count inconsistency. The table will need to be repaired before transactions can be committed properly. (2065)
>>
>>I do notice that this file does not exist at the time of the error, but have not pinpointed when this file get's created/deleted. I am not all that familiar with these .tmp files.
>>
>>Any suggestions? Thanks in advance.
>>
>>Mike
>
>
>SET TABLEVALIDATE TO 1
>
No... not really documented as such, but SET TABLEVALIDATE is outside the scope of this problem.
The 2065 error is related strictly to TRANSACTION processing, at least as I judge it.
Note, for instance, that this 2065 occurs on a .TMP file, while SET TABLEVALIDATE does not affect .TMP files.
The .TMP file in questions is an "internal buffer" file. I have managed to 'capture' one and learned this when trying to open it using a new instance of VFP.
I sure wish that MS could get to the bottom of the whole 2065 issue (not just these extra ones coming to us via VFP9)!
cheers