>>>>Did you add NOFILTER clause at the end? Did it speed up the process? How many records are in the table and how many satisfy the filter criteria?
>>>
>>>I suspect he's getting the equivalent of a SET FILTER. So there really is no data being transferred as would be the case with the NOFILTER. It's probably faster than with the NOFILTER.
>>
>>Yes, I suspect it too.
>>
>>What is VFP version? I don't recall did we have NOFILTER in VFP6? AFAIK we got it in VFP8.
>
>I think he said VFP9 SP1.
Thanks. Having Invalid Seek Offset problem on my own I didn't read the whole thread.
If it's not broken, fix it until it is.
My Blog