🚀 go-pugleaf

You can try ADOQuery1->ParamCheck = false;


"Yongduk Lee" <ydlee@ssaboo.co.kr> escribi� en el mensaje
news:3b84c211_2@dnews...
> 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
>
>
>