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!

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=egroupweb/S=1705115386:HM/EXP=1080022648/A=1950447/R=0/SIG=1245hvqf1/*http://ashnin.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/>.
>
>
> .