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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
