Hi!

Did you try following:

LOCATE FOR IDcolumnname == (.ID)

???

>Hi There.
>
>We discovered an extremely slow Locate statement in our application.
>When using LOCATE FOR and applying a WITH statement for the condition it is better to take a lunchbreak.
>
>for instance;
>where Thisform.ID is a formvariable storing the ID of the record to be found
>
>With Thisform
>LOCATE FOR IDcolumnname == .ID
>Endwith
>
>takes upto 10 seconds while
>
>LOCATE FOR IDcolumnname == Thisform.ID
>
>Takes less then 1 second
>
>Why??
>(a SEEK statement does not appear to be affected)
>
>Geert van Snik
>Zorgned Automatisering B.V.
>Wageningen, The Netherlands