>>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.