Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Proper cursor buffering
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00183097
Message ID:
00183182
Views:
19
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform