A filter only controls what you "see". VFP still steps through the table until it finds the next record meeting the filter condition. Therefore, a SEEK is always the fastest choice.
>Here is some code :
>
>SELECT appur
>SET FILTER TO ident = the_ident
>GO TOP
>DO WHILE !EOF()
> ...do stuff...
> SELECT appur
> SKIP
>ENDDO
>
>I have an index on appur.ident
>
>Would it be faster to do a seek and do the work around it ? And why if the filter is optimized by rushome ?
>
>Thanks
>Eric
I try to stay online, to get better information.
I try to get away from the office once in a while..
But they KEEP... PULLING.. ME.. BACK.. IN!!!
