I use events for notification of changes to lookup tables. But its a
sledgehammer approach. If there is even a small change to a table then
the client side cache is flushed and a total refresh is performed next
time it is required.

For your scenario, I have a socket on the server which bounces
messages between connections. Since the layout of the packet being
sent is in my control I can include as much detail as necessary.

My own application handles airport checkins. When a passenger checks
in, a message is sent to other connections with the flight ID and
passenger ID. When this message is received, the application will
broadcast it to any open forms to see if they want to handle it.

Dave

--- In firebird-support@yahoogroups.com, "sasidhardoc"
<madhusasidhar@n...> wrote:

> I want to use POST_EVENT in my database to monitor changes in a table.
> Suppose I have a Table with fields STOCK_ID (generator value) and
> STOCK_PRICE. I want my application to respond when the stock price is
> changed. I intend to do this with a POST_EVENT inside an UPDATE Trigger.
> But, if my application is only viewing a few stocks, then, the
> application should be able to discern if the POST_EVENT was raised by
> a change in STOCK_PRICE of the stocks it is viewing. My question is,
> how do I inform the application as to which record was modified? I
> suspect I could do this using
> POST_EVENT event;
> where event variable = STOCK_ID
> However, my database has several tables with _ID fields that I want to
> monitor and the generator values may be identical.