How to detect or monitor new records ?

[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?

[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

[axilus]

Thank you man

[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.