>>>If you add the SELECT a before you do the SUM, the SUM will not move b's pointer. The ENDSCAN will automatically reselect b to continue the SCAN.
>>
>>Hi Fred,
>>
>>I saw so many times threads, that SCAN would reselect original table at the end automatically, still I can not get rid of habit to reselect it myself from precaution. Is there a speed benefit, if I would not reselect?
>>
>>Sorry for unrelated question...
>
>Nadya,
>
>I don't know that there is any measurable speed benefit, but the ENDSCAN command does re-select the proper area itself. Though I do remember there was problem with this a long time ago (FP1.0x or FP2.x ???), where the area was NOT reselected. No problem with re-selecting it, if it makes you feel more comfortable.
Thanks for the answer, Fred. I'll just try to not re-select and see, if I gain something :)
Thanks.
If it's not broken, fix it until it is.
My Blog