Ali Gökçen wrote:

> Hi Lester,
> why don't you use this for cancel operations:
>
> TICKET_ID = - PRIMARY_KEY_ID;
>
> it will prevent any duplication and you can identify all canceled
> tickets by ticket_id<0. it is my favorite tecknique for cancelled
> rows.

Lateral thinking :)
Of cause that works fine !
And since the ID is obtained from a single generator ticket_id never
matches appoint_id either ;)

But I'd still like to know why the update trigger is giving a problem ?

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
Treasurer - Firebird Foundation Inc.