Subject Re: [firebird-support] Re: index unexpectedly deleted
Author Lester Caine
Ali Gökçen wrote:

> Hi Lester,
> why don't you use this for cancel operations:
> 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.