Subject Re: [firebird-support] Send event to client after row edit ?
Author Yossi Zaig
> Your message is a little bit ambiguous, but if you want to do what I'm
> interpreting:
>
> * Create a trigger for the table. Put in it the validation code
> necessary to post the event when the "golden row" is modified.
>
> * Create a section in the client to capture the event and refresh the row.
>
> (Possibly I'm repeating the obvious, but I couldn't interpret very
> well what do you want to do, and the situation.)
>
> Cheers,
>
> Raúl
>
Hi.

On the client side I run an application with customers list with there
balances,
I want to notify all the clients when some client updates the customer row
in the Database, I only want to notify the clients that a specific row was
updated, when the client will get the event that one row was updated it will
query the database for this row only so I will not have to run the all
query again and fetch all the rows (That is what I do today, I Post Event in
the After Update trigger my clients gets the event and refresh the all view,
but this takes alot of time and network traffic)

Thanks
Yossi.