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 <[email protected]> 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-) >
