At 06:42 PM 4/1/2011, Dave McCann wrote:
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?
Dave,
In your specific situation, instead of PROPERTY REFRESH
<formtablename> 'REFRESH',
try the following:
Here's how:
PROPERTY TABLE <formtablename> 'CLOSE'
PROPERTY TABLE <formtablename> 'OPEN'
First PROPERTY command will close the dataset.
Second PROPERTY command will re-open/refresh the dataset.
That's all there is to it!
Very Best R:egards,
Razzak.
