Hello:

I tried your suggestion of new. and it works fine. I guess I don't
understand why new.jobno is valid yet jobno gives me an "unknown
column" error but since it works I guess I won't complain.

Thanks much

Geno

--- In IBObjects@y..., "Thomas Steinmaurer" <ts@i...> wrote:
> 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@a...]
> > Sent: Thursday, February 14, 2002 10:20 PM
> > To: IBObjects@y...
> > 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/
> >
> >
> >
> >