>Hi everybody,
>
>I have a table set in the particular order and then a
>
>I'm doing a SCAN on the table with some FOR and WHILE conditions.
>In the beginning on the scan I'm saving recno, then there are some calculations involving this table, then I restore order on this table and goto saved recno. I also update some fields in this table that don't participate in FOR/WHILE.
>
>I'm getting record is out of range on the ENDSCAN command.
>
>Do you know why I'n having this problem and how can I fix it?
>
>Thanks in advance.

Naomi,

Within a scan i would either

open the table being scanned as "AGAIN alias temp2" and sum in that

or

select sum() from (alias()) WHERE xyz=abc into array xxx

so as not to move the pointer

hth

Nigel