Geno,

for working with stored procedures and triggers,
take a look at:

- Interbase Language Reference p. 161ff (the Beta
documentation is available from the Borland web
site)

- http://www.ibphoenix.com/ibp_intro_sp_trig.html

Hope this helps!

Regards,
Thomas Steinmaurer
http://www.iblogmanager.com

> -----Original Message-----
> From: slsolutions2002 [mailto:strtline@...]
> Sent: Thursday, February 14, 2002 10:58 PM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Using parameters in a trigger
>
>
> 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/
> > >
> > >
> > >
> > >
>
>
>
> __________________________________________________________________
> _________
> 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/
>
>
>
>