General information
Category:
Coding, syntax & commands
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only