>This is a real problem. I posted this issue a long time ago, see thread #
236192. Never did get a solution, I ended up having to write a stored database procedure to trap when the error occurred.
>
>If you find anything new out, please let me know.
Eric,
As I said in the prior posing, the problem happens when the header thinks there is one less record than there really is in the file. If you can write code using fopen(), fclose(), etc. (the low level file funcions in VFP) then it is easy to fix by adjusting the file length to what it should be. You need to be able to read the header and convert hex to dec and back again. If you are not comfortable with all that then the best way to fix it is to copy the file to a temp, zap the file and append back in from the temp file. Any way you do it, it has to be done with the file open exclusive. I always include a reindex prg in all my systems and I put it in there.
Hope this helps.
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn