URGENT!!: How to refresh in realtime a DBGrid with MyDAC ??
-
- Posts: 5
- Joined: Mon 04 Feb 2008 20:32
- Location: ALGERIA
- Contact:
URGENT!!: How to refresh in realtime a DBGrid with MyDAC ??
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
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
-
- Posts: 5
- Joined: Mon 04 Feb 2008 20:32
- Location: ALGERIA
- Contact:
Thanks
Thanks a lot
Use the following code:
Also you can use the TCustomMyDataSet.Options.AutoRefresh and TCustomMyDataSet.Options.AutoRefreshInterval properties.
Code: Select all
DataSource.DataSet.Refresh;
-
- Posts: 2
- Joined: Tue 28 Nov 2017 20:45
Re: URGENT!!: How to refresh in realtime a DBGrid with MyDAC ??
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
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
Re: URGENT!!: How to refresh in realtime a DBGrid with MyDAC ??
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
-
- Posts: 2
- Joined: Tue 28 Nov 2017 20:45
Re: URGENT!!: How to refresh in realtime a DBGrid with MyDAC ??
thank you very muchViktorV wrote: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
Re: URGENT!!: How to refresh in realtime a DBGrid with MyDAC ??
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.
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.