Page 1 of 1

How to detect or monitor new records ?

Posted: Sat 09 Apr 2016 21:13
by axilus
Hello,
since i'm new to uniDac, i want to ask more questions and sorry for this !
i have a MySQL database, and i have three clients(users) that fill database(insert records)
and i want to monitor my database (display RecourdCount) in a StatusBar each time one user insert new record.

i'm using uniSQLMonitor but nothing work !
a TTimer do the job but this is not a good idea.

can you help me?
:mrgreen:

Re: How to detect or monitor new records ?

Posted: Mon 11 Apr 2016 14:50
by ViktorV
MySQL server doesn't provide a capability to retrieve the information about modifications made by other users. The only way to learn it is periodical query execution for data modifications. To get other users' modifications fast, you can use the TCustomDADataSet.RefreshQuick method. Note that to use this method, the table must have a unique key field and a TIMESTAMP field. See more details about this method in MyDAC help:https://www.devart.com/mydac/docs/?deva ... olean).htm

Re: How to detect or monitor new records ?

Posted: Mon 11 Apr 2016 20:20
by axilus
Thank you man

Re: How to detect or monitor new records ?

Posted: Tue 12 Apr 2016 12:44
by ViktorV
Thank you for being interested 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.