Try to use the context variable NEW with the column name.

For example (inside your after insert trigger):

EXECUTE PROCEDURE YOURPROCEDURE(NEW.YOURCOLUMN);

Thomas

> -----Original Message-----
> From: slsolutions2002 [mailto:strtline@...]
> Sent: Thursday, February 14, 2002 10:20 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Using parameters in a trigger
>
>
> I am trying to create a after insert trigger that will execute a
> stored procedure. I need to pass one of the fields to the stored
> procedure. No mater what I do I get a unknown column error. How can
> I pass a a field as a variable to the stored procedure from within
> the trigger. Thanks.
>
>
>
>
> __________________________________________________________________
> _________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> __________________________________________________________________
> _________
> http://www.ibobjects.com - your IBO community resource for Tech
> Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>