Subject Re: [firebird-support] How to skip a trigger in the same trigger?
Author Dimitry Sibiryakov
14.04.2016 13:24, Gabor Boros gaborboros@... [firebird-support] wrote:
> 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
> the UNIQUE.

You'd better to remove IsDefault field at all and create a reference to default record
in other table.