🚀 go-pugleaf

Using ADOQuery, I am trying to send folloing statement.

CREATE TABLE a (a_id CHAR(32) PRIMARY KEY, time_of_op DATE);
CREATE SEQUENCE a_seq;
CREATE TRIGGER a_tri BEFORE INSERT ON aaa FOR EACH ROW
BEGIN
   SELECT CONCAT (TO_CHAR(:new.time_of_op, 'YYYYMMDD'),
               LPAD(a_seq.NEXTVAL, 12, '0')) into :new.du_id FROM DUAL;
END;

Like

   ...
   ...

   ADOQuery1->SQL->Add("CREATE TRIGGER a_tri BEFORE INSERT ON aaa FOR EACH
ROW");
   ADOQuery1->SQL->Add("BEGIN");
   ADOQuery1->SQL->Add("SELECT CONCAT (TO_CHAR(:new.time_of_op, 'YYYYMMDD'),
");
   ADOQuery1->SQL->Add("LPAD(a_seq.NEXTVAL, 12, '0')) into :new.du_id FROM
DUAL;");
   ADOQuery1->SQL->Add("END");
   ADOQuery1->Open();

   ...
   ...

The problem is that ADO thinks :new is the parameter name while it is not,
and
gives me an exception. What should I do? Please help me.

Thanks.

--

Yongduk Lee
ydlee@ssaboo.co.kr