| Subject | Re: [firebird-support] How to skip a trigger in the same trigger? |
|---|---|
| Author | Gabor Boros |
| Post date | 2016-04-14T11:24:19Z |
2016. 04. 14. 13:09 keltezéssel, 'Martijn Tonies (Upscene Productions)'
m.tonies@... [firebird-support] írta:
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.
Gabor
m.tonies@... [firebird-support] írta:
> Hi,The table have many fields and a UNIQUE constraint with four fields, one
>
> First question: why do you have an UPDATE <table1> in a BEFORE UPDATE
> trigger on <table1>?
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.
Gabor