Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Detect changes in buffered table or view
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00304384
Message ID:
00304392
Views:
22
>I've got a buffered view (optomistic table buffering) in a grid. When the form is navigated, I want to prompt the user to update or revert any changes that have been made in the grid (all or nothing, not individual records), but only if something has changed.
>
>Is there a function that can give me that status, or do I need to scan through and GETFLDSTATE() every row, like this:
>
>
>scan
>   for nFieldNum = 1 TO fcount()
>      if getfldstate(nFieldNum) = 2
>         lModified = .T.
>         exit
>      endif
>   endfor
>endscan
>
if this is all records or nothing, all you need to find is if any record was modified. You have a modified record if GetNextModified() returns a value greater than zero.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform