>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
Use GETNEXTMODIFIED() instead of GETFLDSTATE() when using table buffering to determine if any records have changed.
Once your on the change record, you can use GETFLDSTATE() to check specifics.
Insanity: Doing the same thing over and over and expecting different results.