Pradeepkumar, Pyatalo (IE10) wrote:
> Thanks a lot for ur help.
> In the trigger, I am checking if a field is updated or not. The syntax I
> use is
>
> IF UPDATE(CreateTime) THEN
> ....
> ....
> END IF;
>
> Is this syntax correct.
No, and I don't recall seeing anything like it in the manuals.
IF OLD.CreateTime <> NEW.CreateTime THEN ...
-- Richard Huxton Archonet Ltd