Thread: DataSets in Delphi

Hi Friends,

I'm using Delphi 3 and ODBCExpress Components do Access Data in PG. The
problem is that the data can't be refreshed, ie., when some station updates
a table, the others keep seeing old data! The default command Refresh from
ODBCExpress and even Delphi TDataSet doesn't work.

Does anyone have any idea?

Thank you,

Marcio Alexandroni.

> I'm using Delphi 3 and ODBCExpress Components do Access Data in PG. The
> problem is that the data can't be refreshed, ie., when some station updates
> a table, the others keep seeing old data! The default command Refresh from
> ODBCExpress and even Delphi TDataSet doesn't work.
> 
> Does anyone have any idea?

I've run into same problem and I over came it by doing 

dataset.Close;
dataset.Open;

and that seemed to do the trick, at least in my case.


--Jyry

Hello,
THis is standard Delphi bug. Refresh on sql queries doesn't do much. You
can't easily override it
either, since its not virtual.

Just close and reopen the data set.


Regards,




> Hi Friends,
>
> I'm using Delphi 3 and ODBCExpress Components do Access Data in PG. The
> problem is that the data can't be refreshed, ie., when some station
updates
> a table, the others keep seeing old data! The default command Refresh from
> ODBCExpress and even Delphi TDataSet doesn't work.
>
> Does anyone have any idea?
>