"Richard Huxton" <dev@archonet.com> wrote in message
news:40EBD891.3050205@archonet.com...
> Pradeepkumar, Pyatalo (IE10) wrote:
> > IF UPDATE(CreateTime) THEN
> > ....
> > ....
> > END IF;
> >
> > Is this syntax correct.
>
> No, and I don't recall seeing anything like it in the manuals.
... and it's always an excellent time to read them ...
> IF OLD.CreateTime <> NEW.CreateTime THEN
> ...
... being mindful of the case where CreateTime might be NULL ...