Subject | Re: [Firebird-Java] Columns Updated |
---|---|
Author | Roman Rokytskyy |
Post date | 2007-02-27T07:29:02Z |
> Is there any way in firebird to get the updatedThere is no function that would return you the list of the updated
> columns in a table.
>
> I was trying to use COLUMNS_UPDATED() in a trigger and
> it seems not working in firebird.
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 columnsIf you're talking about Firebird events, no - there's no such
> updated in a table.
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