Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Getfldstate
Message
De
31/08/2000 16:57:18
 
 
À
31/08/2000 16:51:58
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00411511
Message ID:
00411514
Vues:
8
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform