Hi Marcello,

> Martijn, I do not understand what syntax you are meaning but the
> *GEN_PEDI* was a bold word that the newsgroup filter convert do that.
> After the Helen's suggestion, the stored procedure is working fine but
> any suggestion is welcome!

Yes, I meant the syntax with the *<something>* ... Aha, so it was bold.

Well, that answers my question :-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com

> best regards,
>
>
> ..::
> Marcello Fontolan
> marcello@...
> ::..
>
>
>
> Martijn Tonies escreveu:
>
> > Hi Marcello,
> >
> > > I'm trying use the stored procedure above but it is not accepting
> > > GEN_PEDI as a column.
> > > There is any reserved word that I can use for this, like

var.GEN_PEDI?

> > > How can I contorn this issue?
> > >
> > >
> > > ALTER PROCEDURE TMPEDI_TO_PEDI (PEDI INTEGER)
> > > RETURNS (GEN_PEDI INTEGER)
> > > AS
> > > BEGIN
> > > GEN_PEDI = GEN_ID(GEN_PEDI_ID, 1);
> > >
> > > INSERT INTO PEDI
> > > SELECT *GEN_PEDI*, CLIE, DEMI, VPRO, VSER, 0, 0, 0, 0, LOGG
> > > FROM TMPEDI WHERE PEDI = :PEDI;
> >
> > Out of curiosity - where did you read this syntax?
> >
> > With regards,
> >
> > Martijn Tonies
> > Database Workbench - developer tool for InterBase, Firebird, MySQL &
> > MS SQL
> > Server.
> > Upscene Productions
> > http://www.upscene.com
> >
> >
> > > INSERT INTO PEDIITEM
> > > SELECT *GEN_PEDI*, PROD, BSER, QSAI, VUNI
> > > FROM TMPEDIITEM WHERE PEDI = :PEDI;
> > >
> > > DELETE FROM TMPEDI WHERE PEDI = :PEDI;
> > > DELETE FROM TMPEDIITEM WHERE PEDI = :PEDI;
> > >
> > > SUSPEND;
> > > END
> >
> >
> > *Yahoo! Groups Sponsor*
> > ADVERTISEMENT
> >

<http://rd.yahoo.com/SIG=12c6r09eb/M=268585.4521611.5694062.1261774/D=egroup
web/S=1705115386:HM/EXP=1080022648/A=1950447/R=0/SIG=1245hvqf1/*http://ashni
n.com/clk/muryutaitakenattogyo?YH=4521611&yhad=1950447>

> >
> >
> >
> > ------------------------------------------------------------------------
> > *Yahoo! Groups Links*
> >
> > * To visit your group on the web, go to:
> > http://groups.yahoo.com/group/firebird-support/
> >
> > * To unsubscribe from this group, send an email to:
> > firebird-support-unsubscribe@yahoogroups.com
> >

<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>

> >
> > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> > Service <http://docs.yahoo.com/info/terms/>.
> >
> >
> > .
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>