Help on multi user access (mysql)

[dinko]

How can I automatically update records that has been changed from other user? Calling Refresh every X seconds (timer) its overkill for my app. It should be a way to automatically notified for changes made (insert, update or delete) so I can have an app that would support "live-updates". I am using MySQL.

Thank you in advance

[ViktorV]

MySQL doesn't provide any capability for getting information about changes made by other users without a query to the server. To get this information quickly, you can use the TCustomUniDataSet.RefreshQuick method. Note, that this method requires the table to have a unique key fields and a TIMESTAMP field. See more details about TCustomMyDataSet.RefreshQuick in the MyDAC documentation: http://www.devart.com/mydac/docs/devart ... olean).htm

[dinko]

If I change from mysql what you suggest? Maybe FireBird will help me to make it ever easier and accurate?

[ViktorV]

Firebird implements event support mechanism, that allows to generate messages (e.g., about database modification) on the server side and send them to client applications. See more details about Firebird events in the documentation: http://www.firebirdsql.org/file/documen ... events.pdf
Using UniDAC, you will be able to organize event handling in the application with the TUniAlerter component. See more details about this component in the IBDAC documentation: http://www.devart.com/unidac/docs/devar ... lerter.htm