> Just a new idea:
>
> What about deleting the old row, in a "BEFORE INSERT" trigger?
> Insertion would stay insertion. This should work.
>

well, that was what I've basicly proposed (enhanced by merging),
keep in
mind, that it isn't something I use or promote (I am perfectly
acknowledged
of the stored procedures superiority here), I am just asking aroud
for
possibilities. I am designing the database however, and although I
have to
create triggers for most tables for most events, I'd rather avoid
large
number of stored procedures and I'd want to fit as much as possible
into the
triggers.

thanks for insight Helen.


CUIN Kaczy