Refresh question

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
gwardell
Posts: 1
Joined: Mon 11 Aug 2008 12:49

Refresh question

Post by gwardell » Wed 20 Aug 2008 10:02

Hi,

I'm noticing that when two copies of my application are running, if one updates a record, the update doesn't show in the other copy.

Is there a setting that will cause the changes to the table to be picked up by other copies, or do I need to have a timer in my app to periodically poll for changes by doing a refresh?

I'm using MyConnection, MyTable, and MyDataSource and the VCL Data Aware controls.

I have MySQL DAC 5.50.36.

Gary

eduardosic
Posts: 387
Joined: Fri 18 Nov 2005 00:26
Location: Brazil

Re: Refresh question

Post by eduardosic » Wed 20 Aug 2008 11:29

gwardell wrote:Hi,

I'm noticing that when two copies of my application are running, if one updates a record, the update doesn't show in the other copy.

Is there a setting that will cause the changes to the table to be picked up by other copies, or do I need to have a timer in my app to periodically poll for changes by doing a refresh?

I'm using MyConnection, MyTable, and MyDataSource and the VCL Data Aware controls.

I have MySQL DAC 5.50.36.

Gary
Hi!
You need to use TMyTable.Options.AutoRefresh = True and TMyTable.Options.AutoRefreshInterval

is the solution.

Post Reply