| Subject | Re: Declare variables in trigger. |
|---|---|
| Author | Adam |
| Post date | 2006-08-10T01:13:42Z |
--- In firebird-support@yahoogroups.com, "Julio César Carrascal
Urquijo" <jcarrascal@...> wrote:
Switch the AS and DECLARE VARIABLE, and include a semicolon on the end
of the declare variable line.
ie:
create trigger BsCompanyPopulate for Company
active after insert position 0
AS
declare variable AdminsGroupId as numeric(18,0);
begin
...
Urquijo" <jcarrascal@...> wrote:
>It works if there are no syntax errors:
> Is it possible to declare variables inside a trigger? I need to insert
> some rows and relate those in another table.
Switch the AS and DECLARE VARIABLE, and include a semicolon on the end
of the declare variable line.
ie:
create trigger BsCompanyPopulate for Company
active after insert position 0
AS
declare variable AdminsGroupId as numeric(18,0);
begin
...