In article <aiq36o+ooaq@...>, ryan@... says...

> Hi there,
>
> What am I not understanding? Do I close the query, make the WHERE
> clause reflect the record I want then re-open it?
> I guess I just don't understand why all records are fetched when
> doing a locate.
> btw, I am doing a locate on the PK.
>
> Rgds,
> -Ryan

When you are doing a locate it has to scan the relevant data from the
table to "locate" your desired value. If you have an index in BOTH
ascending and descending order on that field it should run much faster.

Allen.