Eko Subagio wrote :
>Hello guys,
>I have been creating trigger using sapdb, so far declaration of one variable inside
>of trigger
>working fine, but when i declare two local variable, the sql studio said it is error
>with the second
>declaration of variable ?
>example:
>CREATE TRIGGER test AFTER INSERT ON TestTable
>EXECUTE (
>VAR Var1 varchar(10);
>VAR Var2 integer; <---- error goes here
>)
Please just omit the second keyword 'VAR' :
CREATE TRIGGER test AFTER INSERT ON TestTable
EXECUTE (
VAR Var1 varchar(10);
Var2 integer;
Regards,
Thomas
--
Thomas Anhaus
SAP DB, SAP Labs Berlin
[EMAIL PROTECTED]
http://www.sapdb.org/
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
