Re: GET LAST ID INSERT

I've found my mistake: I was closing my connection between first and
second point....

Now works.....thank you very much!!!!!

olly(at)lfix(dot)co(dot)uk (Oliver Elphick) wrote in message news:<1064426468(dot)6612(dot)375(dot)camel(at)linda(dot)lfix(dot)co(dot)uk>...
> On Wed, 2003-09-24 at 11:49, Maurizio Faini wrote:
> > I tried to use CURRVAL, but it gives me this error:
> > IS NOT YET DEFINED IN THIS SECTION
>
> That indicates that in the current session you haven't yet used
> nextval() on the id specified in the currval() call.
>
> > this is what i do:
> > 1) INSERT (id,....) VALUES (nextval('...id_seq'),.....etc...
> > 2) SELECT currval('...id_seq');
> > and now there is error.
> > 3) get rs
> > 4) another insert query with rs current val
> >
> > why this not work?
> > where i make a mistake?
>
> I can't see what is wrong here. Please post a transcript of the actual
> session; your editing has wiped out whatever you did wrong.
>
> --
> Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
> Isle of Wight, UK http://www.lfix.co.uk/oliver
> GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
> ========================================
> "And we know that all things work together for good to
> them that love God, to them who are the called
> according to his purpose."
> Romans 8:28
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend