URGENT!!: How to refresh in realtime a DBGrid with MyDAC ??

[ghazaliove]

Hello,
When i try to insert new Record from the CLIENT application , but i can't see the new record in the DBGrid of the server application(where is stored the database?

How can i see the changes in the DBGrid of server application in realtime??

Thanks

[Dimon]

You should call the TDataSet.Refresh method when you want to get up-to-date information. You can call it on a Timer event handler.

[ghazaliove]

Thanks a lot

[FerCastro]

You should call the TDataSet.Refresh method when you want to get up-to-date information. You can call it on a Timer event handler.

Hello Dimon, and, what if i am using DataSource instead Dataset?

Best regards

[Dimon]

Use the following code:

Code: Select all

DataSource.DataSet.Refresh;

Also you can use the TCustomMyDataSet.Options.AutoRefresh and TCustomMyDataSet.Options.AutoRefreshInterval properties.

[fadly.syam09]

I have the same Questions,..

but in my case, i'm using TMyConnection + TMyQuery only..
when the user has made a insert record in client side, how can i monitoring the change of the Database by realtime without using TTimer in my Delphi Form Application?.. is that any way in MyDac to do that, i realized that this is hard to make hapen but i do need this function in my Application.

thank you very much, i hope i can get the answer as soon as possible

[ViktorV]

MySQL doesn't provide a capability to retrieve information about changes made in another query without request to the server. For quick retrieving of changes made by other quires, you can use the TCustomDADataSet.RefreshQuick method. Note, that usage of this method requires the table to have unique key fields and a TIMESTAMP field. See more details about this method in MyDAC help: https://www.devart.com/mydac/docs/devar ... olean).htm

[fadly.syam09]

MySQL doesn't provide a capability to retrieve information about changes made in another query without request to the server. For quick retrieving of changes made by other quires, you can use the TCustomDADataSet.RefreshQuick method. Note, that usage of this method requires the table to have unique key fields and a TIMESTAMP field. See more details about this method in MyDAC help: https://www.devart.com/mydac/docs/devar ... olean).htm

thank you very much

[ViktorV]

Thank you for the interest in our products.
If you have any questions during using our products, please don't hesitate to contact us - and we will try to help you solve them.