table events

[krispaks]

is there any event called when data from a certain table inside a database is changed?

i want my UI to be always updated when a data inside a table is changed... how do you implement this?

need some help.

 

[cjard]

is there any event called when data from a certain table inside a database is changed?

No

i want my UI to be always updated when a data inside a table is changed... how do you implement this?

You dont. Not even pro programmers would waste their time implementing this i'm afraid.

If there is soemthing that is really mission critical that updates must be conferred throughout the enterprise, then use some form of network broadcast UDP by the client that is making the change; dont involve the RDBMS at all.

A simpler approach might be simply to requery the data before you want to use it

 

[krispaks]

tnx for the reply...
Ive read some forums and they introduced Notification Services...

would this work???

 

[Stonkie]

You could add a time column to your tables, update that time column every time you update something in a row and then just load back the data that has changed. That way, you can have a timer load back the rows that have been changed since your last load and refresh it. This could be like every 5 secs or something so that propagating the changes from the database to your multiple client UIs would take 5 secs maximum.

It still isnt as good as a database event and you CANNOT depend on this to ensure concurrency safety, but it should do the trick of updating the UI as the user is looking at it...