General information
Category:
Coding, syntax & commands
Perry,
I believe the problem is the LOCATE command within the SCAN...ENDSCAN loop. Both move the record pointer. Is it your intention to affect the record that meets the LOCATE criterion, if so you don't need SCAN...ENDSCAN. If you want to affect all records meeting a certain criteria (the FOR clause in your SCAN) then you shouldn't need the LOCATE command.
Good Luck.
-Dore
>Hi all,
>
>I have a nested loop with 2 FOR...ENDFOR and a SCAN...ENDSCAN.
>
>FOR I = 1 TO ALEN(myArray1)
>sele my table1
>set filter to myField1 = myArray1[I]
>go top
>FOR J = 1 TO ALEN(myArray2)
>sele mytable1
>go top
>SCAN FOR myField2 = myArray2[J] WHILE !EOF('myTable1')
>locate for myVar = myTable2.myField1
>.
>.
>.
>
>ENDSCAN
>ENDFOR
>ENDFOR
>
>When I debug the loop, the scan searches in myTable 1 properly for myArray2[1]. When the FOR loop is incremented, the record pointer is still looking at records with myArray2[1] and seems to overlook the change in parameters.
>
>TIA
Previous
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