>I am working on a big view altering some records and when I close the form I want my program to update the MySQL table.
>
>As the table has a lot of entres I would like to use GETNEXTMODIFIED to jump quickly to the next altered record in order to make the update process faster.
>
>The problem is that once a issue a TABLEUPDATE command, I can´t continue altering the same VIEW because GETNEXTMODIFIED won´t work again.
>
>What am I missing?
You must be using a wrong parameter in the TABLEUPDATE -command.
Try this:
SELECT MyFile
GO TOP
lnStart = RECNO()
SCAN
lnNextMod = GETNEXTMODIFIED(lnStart)
IF lnNextMod = 0
EXIT
ENDIF
GOTO lnNextMod
TABLEUPDATE(0, .T.)
SKIP
lnStart = RECNO()
SKIP -1
ENDSCAN