db-derby-user mailing list archives

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