OK, I can see how there would be a problem with re-creating an index for zero records if TRIM were part of the index expression. I learned a long time ago not to do that. Nor are the field names reserved.
In any case .... it seems like simply removing all tags and filters before the ZAP eliminates the problem anyways.
Thanks,
>>Nope, I don't ever do that.
>>
>>And, even if I did, I would have a hard time seeing it's relevance to a ZAP. Or why that would cause the error message "Line Too Long".
>
>Well, what IS the index expression? And the filter expression? You may want to rename fields, if the are incriminating (grin), but watch that the field names themselves are not reserved words.
>
>I suspect that after doing the ZAP, Visual FoxPro will have to re-create the index - for zero records. And, if there were an expression with alltrim(), that would immediately cause an error (because of the zero-length string), which might not appear when there are actually some records.
Jim Nelson
Newbury Park, CA