"Richard Huxton" <dev(at)archonet(dot)com> wrote in message
news:40EBD891(dot)3050205(at)archonet(dot)com(dot)(dot)(dot)
> 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 ...