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
Sent from my BlackBerry� smartphone from Sinyal Bagus XL, Nyambung Teruuusss...!

-----Original Message-----
From: "Leyne, Sean" <Sean@...>

Date: Wed, 20 May 2009 15:07:13
To: <firebird-support@yahoogroups.com>
Subject: RE: [firebird-support] Trigger and St.procedure

> I am already tri
>
> new.win=new.win+_win;
>
> Still error. "Unknown system variable win"

Post the full logic of your trigger and the DDL for the trigger table.


Sean



[Non-text portions of this message have been removed]