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: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc

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?

    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-2017 The PostgreSQL Global Development Group