Sorry guys, but i got the correct result using:
CREATE TRIGGER test AFTER INSERT ON testTable
EXECUTE (
VAR
var1 varchar(10);
var2 integer;
< other trigger statement here >
)
Problem solved
----- Original Message -----
From: "Eko Subagio" <[EMAIL PROTECTED]>
To: "Eko Subagio" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, October 08, 2003 3:18 AM
Subject: Re: declaring other variable inside trigger
> 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]
>
>
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
