Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
GETNEXTMODIFIED, anyone?
Message
De
09/05/2008 19:41:25
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8
OS:
Windows XP
Network:
SAMBA Server
Database:
MySQL
Divers
Thread ID:
01316132
Message ID:
01316189
Vues:
28
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform