Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Proper cursor buffering
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00183097
Message ID:
00183182
Vues:
20
In the help under GETFLDSTATE() it states:

"Returns a numeric value indicating if a field in a table or cursor has been edited or had a record appended, or if the deleted status of the current record has been changed."

The operative words here is "...table or cursor" not current record. If what you say is true (I'm not implying it isn't), I would think more people would be confused.


>I think I see the problem. GETFLDSTATE() gives info about the current record. If you're sitting on an unedited record, GETFLDSTATE() will properly show you that it hasn't been edited, even though other records in the table have been. (Note that -1 specifies all FIELDS in the current RECORD, not all RECORDS in the current TABLE.)
>
>You may want to try this sort of loop, as discussed in the VFP manual under multi-user and buffering issues:
>
LOCAL CurRecno, NextModRecno
>CurRecno = RECNO()
>NextModRecno = GETNEXTMODIFIED(0)
>DO WHILE NextModRecno != 0
>    SavedOK = TABLEUPDATE(.F., .T.)
>    DO WHILE NOT m.SavedOK
>        * Handle reason save failed.
>    ENDDO
>ENDDO
>HTH,
It's "my" world. You're just living in it.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform