I am trying to create a trigger use the following script but I got error when trying to execute it (line 4 column 16):


CREATE TRIGGER "AccountUpdate" AFTER UPDATE OF "AccountNo"
ON "TB_AccountsChart"
BEGIN
  INSERT INTO TB_Log (Form_Name) VALUES (NEWROW.AccountNo);
END

Abdulaziz,

<<
CREATE TRIGGER "AccountUpdate" AFTER UPDATE OF "AccountNo"
ON "TB_AccountsChart"
BEGIN
  INSERT INTO TB_Log (Form_Name) VALUES (NEWROW.AccountNo);
END
>>

try Execute Immediate 'INSERT INTO TB_Log (Form_Name) VALUES (' + Cast(NEWROW.AccountNo as
VarChar) + ')';

Untested.

Uli

Uli

<<try Execute Immediate 'INSERT INTO TB_Log (Form_Name) VALUES (' + Cast(NEWROW.AccountNo as
VarChar) + ')';

Untested.>>

Sorry, but does not work.  I still get an error.

Abdulaziz,

It's very difficult to help you if you don't tell us at least what error
do you get and what EDB version are you using...

--
Fernando Dias
[Team Elevate]

Try following as body of the trigger :

BEGIN
 DECLARE st STATEMENT;
 PREPARE st FROM 'insert into TB_LOG (FORM_NAME) VALUES (?)';
 EXECUTE st USING NEWROW.AccountNo;
END

Raul

"Abdulaziz Jasser" <jasser@cyberia.net.sa> wrote in message
news:19440235-373A-4FF7-85B8-A474521F918D@news.elevatesoft.com...
>I am trying to create a trigger use the following script but I got error
>when trying to execute it (line 4 column 16):
>
>
> CREATE TRIGGER "AccountUpdate" AFTER UPDATE OF "AccountNo"
> ON "TB_AccountsChart"
> BEGIN
>   INSERT INTO TB_Log (Form_Name) VALUES (NEWROW.AccountNo);
> END
>

Raul,


<<Try following as body of the trigger :

BEGIN
 DECLARE st STATEMENT;
 PREPARE st FROM 'insert into TB_LOG (FORM_NAME) VALUES (?)';
 EXECUTE st USING NEWROW.AccountNo;
END>>

Thanks now it works.