You appear to be missing a semicolon after the variable declaration

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]On Behalf Of Julio César
> Carrascal Urquijo
> Sent: Thursday, 10 August 2006 11:04 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Declare variables in trigger.
>
>
> Is it possible to declare variables inside a trigger? I need to insert
> some rows and relate those in another table. This is what I was
> trying:
>
> create trigger BsCompanyPopulate for Company
> active after insert position 0
> declare variable
> AdminsGroupId as numeric(18,0)
> as
> begin
>
> AdminsGroupId = gen_id(SeqGroupId, 1);
> insert into Group (CompanyId, GroupId, GroupCode, GroupName)
> values (new.CompanyId, GroupId, 'admins',
> 'Administradores');
>
> insert into Access (CompanyId, GroupId, FeatureId)
> values (new.CompanyId, :AdminsGroupId, 1);
> insert into Access (CompanyId, GroupId, FeatureId)
> values (new.CompanyId, :AdminsGroupId, 2);
> ...
> end;
>
> The "declare variable... " statement generates an error. Is it
> possible o will I have to call a SP with that code?
>
> Thanks
>
> --
> Julio César Carrascal Urquijo
> http://jcesar.f2o.org/
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>