Subject Re: [Firebird-Java] Columns Updated
Author Roman Rokytskyy
> Is there any way in firebird to get the updated
> columns in a table.
>
> I was trying to use COLUMNS_UPDATED() in a trigger and
> it seems not working in firebird.

There is no function that would return you the list of the updated
columns. In the trigger you have access to new.* and old.* contexts, so
you can do the proper checking yourself.

> Is there anyway using Events to get the columns
> updated in a table.

If you're talking about Firebird events, no - there's no such
possibility. When subscribing for events you have to know the exact
event names and you can't pass the parameters with events. Also, please
note that events are not guaranteed to be delivered in time, only
somewhere after commit of the transaction that generated the event. And
events won't be delivered for each update, instead only the count of the
events since last delivery will be sent.

Roman