Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
TABLEUPDATE(2,.T.) leaves records that are not updated
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00500580
Message ID:
00500707
Vues:
27
>>>I guess I'm missing something here, GetNextModified(0) returns the first modified record. You decide what to do with it. i.e. Fix the error (which you can find by doing a TableUpdate(1)) or cancel the changes with TableRevert(.F.).
>>>Then, call GetNextModified(RecNo) passing the RecNo of the record you just processed. You do this until GetNextModified() returns 0.
>>>
>>>HTH,
>>
>>Something like DO WHILE GETNEXTMODIFIED(0) # 0...
>>
>>Have a good one, and thank's
>
>That is not how you use GetNextModified.
>local lnRecNo
>lnRecNo = 0
>lnRecNo = GetNextModified(lnRecNo, "MyTableAlias")
>do while lnRecNo <> 0
>   && do whatever update you need here
>   lnRecNo = GetNextModified(lnRecNo, "MyTableAlias")
>enddo
Hi Mark,
I believe what he coded will work if he does a TableUpdate(1) or TableRevert(.F.) on each hit.
Bill Armbrecht
VFP MCP
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform