My requirement is when ever a table got updated; I am
interested in the value of that column which got
updated with new values.

Actually mine is a real-time application, where
another application updates a data in a table, i have
to listen for that change and need to show the updated
values in GUI.

How can I achieve this when I register listeners for
tables?

There will be someway we can know which field got
updated in a table right?

I can write triggers for after update, after insert
and after delete etc...Is it necessary i should write
a "Post Event" for every column in a table?

I am new to triggers, So can anyone suggest which is
the good way to get realtime updates from tables to
ui?

If anyone knows how to do that can you please post the
code/triggers?



--- Roman Rokytskyy <rrokytskyy@...> wrote:

> > But i can see only eventName and eventCount
> methods.
> > Is there anyway to get the columnname from the
> events, meaning which
> > column has changed?
>
> No. This you can do only by using different event
> names.
>
> > But i want to know, If i update CUSTOMER_NAME
> column in my java
> > program is it possible for me to get the Updated
> column is
> > CUSTOMER_NAME.
>
> Only if you post different event names for different
> changes. Or you keep a
> log table where you save what was changed. The
> question is whether you
> really need to know such information...
>
> So, the events mechanism is not something like
> "network trigger", you have
> neither "new." nor "old." variables.
>
> Roman
>
>
>
>
> Yahoo! Groups Links
>
>
> mailto:Firebird-Java-fullfeatured@yahoogroups.com
>
>
>
>

Asha.A.V
Software Engineer
SatPath Systems Inc.
46661,Fremont blvd.
Fremont.CA.



____________________________________________________________________________________
Yahoo! Music Unlimited
Access over 1 million songs.
http://music.yahoo.com/unlimited