allies_xposs@... wrote:

> Table name :
>
> Postingtrans (
>
> Mydate date,
>
> Win integer,
>
> Lose integer,
>
> Userby varchar(10));
>
>
>
> Create trigger tposting before update on postingtrans....
>
> Call stposting();
>
> End;
>
>
>
> Create procedure stposting()
>
> Begin
>
> .. Any code to find win or lose
>
> If bwin then Set new.win=new.win+1
>
> Else set new.lose=new.lose+1
>
> End
>
> End
>

new.* context variables are not seen inside your procedure, they just
"exists" inside your trigger.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br