I search on the mailing list
Is it correct ?

VAR Var1 varchar(10);
          Var2 = integer;

----- Original Message -----
From: "Eko Subagio" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 08, 2003 3:05 AM
Subject: declaring other variable inside trigger


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

)

is there any clue to solve this ?

TIA
Eko Subagio


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to