Hi all.

I'm changing multiple rows in a buffered(5) table.

My code is:

SELECT myAlias
DO WHILE myfield = lcVariable and !eof()
replace myfield2 with myVariable
skip
ENDDO

now, after it exits the DO WHILE loop, the record pointer is pointing to a record that has not been changed, so GETFLDSTATE(-1) returns "11111111...".

Must I move the pointer back one (SKIP-1) record after going through the loop. This doesn't seem right.

Any thoughts? thanks