Re: Simple Trigger Question

From: Lee <lduhl_at_corp.realcomp.com>
Date: 28 Jul 2004 06:32:03 -0700
Message-ID: <719532c5.0407280532.6b57947c@posting.google.com>

Sybrand

My appolgies but I'm not sure if you are stating something or asking a question.

I assume you comment means that my check (:New.ImageUrl <> :Old.ImageUrl) is not passing becuase the ":Old.ImageUrl" value is null.

If this is the case, do I solve this problem by using the "NVL" function (IE: (NVL(:New.ImageUrl,'') <> NVL(:New.ImageUrl,''))?

If not could you please recomend the correct solution?

Thank You
Lee

Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote in message news:<2jedg0hg2mvdg95v11u6jeqvr41qgtvj9t_at_4ax.com>...
> On 27 Jul 2004 12:48:48 -0700, lduhl_at_corp.realcomp.com (Lee) wrote:
>
> >What do I need to do to the statment above, to make trigger update the
> >"UpdateDate" field upon the initial change of the "ImageUrl" field?
>
> pointer : what is the result of comparing a non-null value
> (:new.imageurl) to a NULL value (:old.imageurl)?
> a) true
> b) null
Received on Wed Jul 28 2004 - 08:32:03 CDT