Thanks for the info...

Tommy


>>In looking at code at my new job, I came across the following construct.....
>>
>>SEEK avalue
>>SCAN REST FOR thistable.fieldvalue = avalue
>>
>>dahdahdah....
>>
>>ENDSCAN
>>
>>Question....
>>
>>Will the SCAN begin where the REST starts... or will it start over at the beginning of the table because of the FOR?? (A speed concern here.....)....
>>
>>Thanks
>>
>>Tommy
>
>It will start scanning at the current record. The for default is ALL but you changed it to REST. The only difference really between this and the WHILE statement is that this will always leave you at EOF while the WHILE clause will end at EOF or the next record that doesn't match.