db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bruehlicke <bruehli...@gmail.com>
Subject Re: Basic SQL question Update statement
Date Fri, 25 Sep 2009 20:48:06 GMT
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 <bruehlicke@gmail.com> wrote:
> 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 statement
>
> B-)
>

Mime
View raw message