Sorry for miss type of sql syntax it should be :
CREATE TRIGGER test FOR testTable
AFTER INSERT 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:35 AM
Subject: Re: declaring other variable inside trigger
> 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]
