refresh a dbgrid from datamodule (afterpost) from another form (unit)

[fraxzi]

Quote

 

Hi Everyone,

On my datamodule, i have this afterpost on my query.. once the data posted, i'd like to refresh a dbgrid from another form/frame (unit).

If I call TFromAnotherForm.dbgrid.refresh got this error "Owner Form not found."

How to solve this?

 

Thanks in advance.

[Sherzod]

Hello,

3 hours ago, fraxzi said:

On my datamodule, i have this afterpost on my query

?

[fraxzi]

7 minutes ago, Sherzod said:

Hello,

?

from the above procedure, I called:

error is "Owner Form not found."

[Sherzod]

Is there more code above?

If grid is related with this DataSet, then it should automatically update...

[fraxzi]

procedure TdmMonitoring01.sqlMonitoringAfterPost(DataSet: TDataSet);
begin
  with sqlMonitoring do
  begin
    Connection.StartTransaction;
    try
      ApplyUpdates; 
      Connection.Commit;
    except
      RestoreUpdates;
      Connection.Rollback;
      MainForm.ShowToast('SAVING FAILED!');
      raise;
    end;
    CommitUpdates;
    Refresh;        // dgGrid not refresh!??? Why?
    MainForm.ShowToast('DATA SAVED!');
  end;
end;

I added "Refresh" to the Query but dgGrid still not refreshed.. The data displayed was not changed. I also confirmed the data was saved..

If I call lik form1.dbgrid.refresh from form2 I get the error "Owner Form not found". So what should be the right approach?

 

Thanks,

Frances

[Sherzod]

Hello,

And if you refresh the grid on the form itself, does it show the updated data?

[zilav]

grdXXX.RefreshCurrentRow ?

[zhyhero]

You can try Event 

EventNotify.zip