I have an odd problem using a DB Grid based on a view in a form,
information is displayed from the view and I have options to edit the
underlying data by using double-click to edit opens a form to edit
selected row of data. When data is saved and I return to the form with
the view in a DB Grid, the updated data does not display. I am using a
RECALC TABLES and have also tried PROPERTY TABLE <formtablename>
'REFRESH'. The data IS saved, it just doesn't refresh on the DB Grid.
I also have a button on the same DB Grid form that updates one of the
values (using UPDATE in code) to change a value in the underlying table
for the selected row. Doing this with RECALC TABLES does properly show
the updated value in the View. It is doing the same thing really, just
through code vs an edit form.
Any thoughts?