General information
Title:
Updating with local views
I have a local view that has table buffering set. I seem access and update client records fine (without error) using tableupdate(). However a very strange thing happens if I do not exit the app or switch to another client. When I debug prior to the tableupdate()data.surname = "King" and view.surname = "Knight" which is normal. After error free tableupdate() the data.surname = "Knight" and the view.surname = "Knight" which is again normal. If I select * from data and browse for the updated record, the queried result set shows the original surname of "King" vs the updated surname of "Knight". If I exit the app everything has saved correctly or if I access another client then re-run the query it will give me the correct surname. Does anyone have any I dea why this happens ?
Thanks
Scott
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only