Kurt Federspiel wrote:

>> --- Martijn Tonies <m.tonies@...> wrote:
>>
>>> I have data going into the Data table, but
>>> new_data is not being updated. Since there is no
>>> dirty read,
>> Do note, that your trigger is set to fire on UPDATE,
>> not INSERT.
>
> Oh, please....that was pathetic.

Why? It's a statement of fact
New data is INSERTED, the UPDATE trigger is only used when you UPDATE existing
records in the table. This way you can have different actions for insert and
update, although you can now use the same trigger for both.

--
Lester Caine - G8HFL
-----------------------------
Contact - http://home.lsces.co.uk/lsces/wiki/?page=contact
L.S.Caine Electronic Services - http://home.lsces.co.uk
MEDW - http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Treasurer - Firebird Foundation Inc. - http://www.firebirdsql.org/index.php