2016. 04. 14. 13:09 keltezéssel, 'Martijn Tonies (Upscene Productions)' [email protected] [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 the UNIQUE. Gabor ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
