Re: Basic SQL question Update statement

bruehlicke bruehli...@gmail.com writes: I have a trigger something like . UPDATE X SET A=(SELECT . ) Now, if the embedded SELECT statement returns no rows I would NOT like to change the value from A to bank/null but let it keep the value it currently has. Any suggestions for a

Re: Basic SQL question Update statement

Tusind takk. Virker perfekt. On Sun, Sep 27, 2009 at 1:22 PM, Knut Anders Hatlen knut.hat...@sun.com wrote: bruehlicke bruehli...@gmail.com writes: I have a trigger something like . UPDATE X SET A=(SELECT . ) Now, if the embedded SELECT statement returns no rows I would NOT like

Basic SQL question Update statement

I have a trigger something like . UPDATE X SET A=(SELECT . ) Now, if the embedded SELECT statement returns no rows I would NOT like to change the value from A to bank/null but let it keep the value it currently has. Any suggestions for a one liner which fits into a create trigger

Re: Basic SQL question Update statement

I cannot set the Column to NO NULL, Maybe a hack - but just added another trigger which will react on any NULL's inserted and convert them to the default value. B-) On Fri, Sep 25, 2009 at 3:08 PM, bruehlicke bruehli...@gmail.com wrote: I have a trigger something like . UPDATE X SET