Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GETNEXTMODIFIED, anyone?
Message
From
09/05/2008 19:41:25
 
 
To
09/05/2008 13:43:03
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows XP
Network:
SAMBA Server
Database:
MySQL
Miscellaneous
Thread ID:
01316132
Message ID:
01316189
Views:
27
>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.)   &&Update current row only, force updates
   SKIP
   lnStart = RECNO()
   SKIP -1
ENDSCAN
Pertti Karjalainen
Product Manager
Northern Lights Software
Fairfax, CA USA
www.northernlightssoftware.com
Previous
Reply
Map
View

Click here to load this message in the networking platform