Thanks Thomas and Daniel

I have the documentation and read it over sevweral times before
posting my messages. Although I read about old and new, it never hit
me that I needed to use them. Now that I read your explanation and
read it again it is painfully obvious what the variables do and why I
MUST use new. Thanks again

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