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

Nigel,

Very good Idea. Perhaps I just have to change the other procedure to do that instead of playing games with record pointer. I was trying to leave the old code intact, but in lots of cases it's just plainly wrong and I have to modify it anyway...