Razzak: Sorry to say I just tried that and it still does not refresh
the db grid properly. As I indicated, I have a button on same form
which through code updates a column value, that shows up, nothing when I
use an edit form though. Very strange.
On 4/1/2011 3:49 PM, A. Razzak Memon wrote:
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.
