Here's the scenario..
I've got a view on a table...
I do a CURSORSETPROP("Buffering", 3) on it...
I change some values in the view
I do a TABLEUPDATE(2, .T.)
2 means write all records if table buffering or just the current if record buffering (says the manual)
.T. means force the changes even if the data in the record has changed
Now I can look at the view AND at the source table and BOTH are the same and reflect the NEW values.
Now here's the tricky part...I am using this view to populate a grid so whenever the grid is refreshed I make sure to do a REQUERY.
Now the instant I do the REQUERY I notice that my values in my view GO BACK to what they were originally!!!
And my actual table on disk STILL has the correct, new values!
HELP!!!!!!
I've been doing this for hours, and I've finally narrowed it down to this..
But this seems...impossible...
Thanx