Skip site navigation (1) Skip section navigation (2)

getting last oid in Visual Basic

From: iloz(at)www(dot)recursor(dot)com
To: pgsql-odbc(at)postgresql(dot)org
Subject: getting last oid in Visual Basic
Date: 2002-10-01 14:10:49
Message-ID: Pine.LNX.4.21.0210011605200.10802-100000@www.recursor.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi!

I have problem with getting the oid of last inserted row in Visual Basic.
If I update a recordset with a new row, and then I execute a query:
"select :LASTOID as loid"
then I get: ERROR:  parser: parse error at or near ":"

May be the driver connects to the server again, and cant't get the oid?

How can I get it with ODBC?

Thanks
Zoltan
__________________________________________________________________________
    Nagy Zoltan         iloz(at)recursor(dot)hu         Phone: +36-30-2699112


pgsql-odbc by date

Next:From: Dave PageDate: 2002-10-01 14:19:00
Subject: Re: [NOVICE] GUI Interface
Previous:From: Dave PageDate: 2002-10-01 14:02:40
Subject: Re: [ NOVICE ] Name of database under postgresSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group