Handle db events in external programming application

[thiago777]

Hello all,

I am in need of detecting when an update/change occurred in the database, but checking it every second by selecting queries is not good as will take, of course, too much process time..

Is there a way of creating a method as an event handler of an event happening inside the database??

Whats the best solution for this? so I could update my VB screen for example only when changes occurr in the database..

thanks in advance,
Thiago.

[Clanguage]

Thiago,
Do you have access to the database? If you do, just create an insert/update trigger.

[ilearneditonline]

Thiago,
Do you have access to the database? If you do, just create an insert/update trigger.

I know how to write triggers, but how would you have it notify the VB application that there was a change?