>Hi everyone
>
>I've been using the 'SCAN FOR' command and the 'LOCATE FOR' command in some of my applications. In terms of speed - does anyone know which is supposed to be faster? They appear to work about the same speed to me...
>

SCAN FOR processes records in the current sort order, identifying eligible records based on the FOR condition. LOCATE positions to the first record meeting the specified FOR condition. If the FOR condition is Rushmore optimizable, the eligible records can be established on either; if not, the records are examined from the logical BOF a record at a time in the current sort order. So they both perform in a similar fashion - the biggest difference is I'm not sure if CONTINUE has to repeat the check for eligible records.