Subject Re: [firebird-support] How to skip a trigger in the same trigger?
Author Gabor Boros
2016. 04. 14. 13:09 keltezéssel, 'Martijn Tonies (Upscene Productions)'
m.tonies@... [firebird-support] írta:
> Hi,
> First question: why do you have an UPDATE <table1> in a BEFORE UPDATE
> trigger on <table1>?

The table have many fields and a UNIQUE constraint with four fields, one
the ISDEFAULT from it (only one default accepted for groups of rows
depend on the other three fields (which included also in the UNIQUE)
value). If the user change the default row to not default and set other
to default in the application I need to set the old default row to not
default because if not do before set the new default the UPDATE violate