Hi,

> Is there some way to create a trigger what works both after insert and
> after update?
> someting like:
>
> CREATE TRIGGER MyTrigger FOR MyTable AFTER INSERT OR AFTER UPDATE
> POSITION 0 AS
> BEGIN
>
> if (new.MyDateField='30.12.1899') then update MyTable set
> MyDateField=null where ID=new.ID;

In Firebird 1 - no. In Firebird 1.5 - yes. Look it up in the 1.5
Release Notes.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com