Catching exceptions, maybe? Greetings.
Walter. On Thu, Sep 19, 2013 at 12:21 PM, Leyne, Sean <[email protected]>wrote: > ** > > > ** ** > > It is as expected, data type constraints are enforced before all other > operations.**** > > ** ** > > What would be the purpose of firing a trigger if the data is not valid?*** > * > > ** ** > > ** ** > > Sean**** > > ** ** > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *W O > *Sent:* Thursday, September 19, 2013 12:00 PM > *To:* [email protected] > *Subject:* Re: [firebird-support] Why IN AUTONOMOUS TRANSACTION doesnt > work here?**** > > ** ** > > > > > **** > > That's right, the trigger never fires when the column is VARCHAR(20) and > the lenght of data is greater than 20.**** > > ** ** > > Is that a bug or it works as expected?**** > > ** ** > > Greetings.**** > > ** ** > > Walter.**** > > ** ** > > ** ** > > On Thu, Sep 19, 2013 at 10:28 AM, Mark Rotteveel <[email protected]> > wrote:**** > > **** > > On 19-9-2013 15:58, Alan McDonald wrote: > > Use an external table to log errors. They are not subject to > > transactions.**** > > But if the trigger doesn't fire, that won't help. > > Mark > -- > Mark Rotteveel**** > > ** ** > > > > > **** > > **** > > >
