syntax
Posted by:
Marco Chan
Date: August 30, 2012 04:09AM
Hi
what wong's with this syntax?
It hightlight the last 2 lines not correct, I wonder if this is the ";" ...
Thanks
CREATE TRIGGER UPD_INTEGRAL_NO BEFORE INSERT ON mt4.mt4_trades
FOR EACH ROW
IF INSTR(BINARY new.comment,'O:') >0 THEN
SET NEW.INTEGRAL_OPEN = MID(new.comment,INSTR(BINARY new.comment,'O:')+2,8);
END IF;
Subject
Views
Written By
Posted
syntax
2105
August 30, 2012 04:09AM
1471
August 31, 2012 06:08AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.