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

getting last oid in Visual Basic

From: iloz(at)recursor(dot)hu
To: pgsql-odbc(at)postgresql(dot)org
Subject: getting last oid in Visual Basic
Date: 2002-10-01 14:26:13
Message-ID: Pine.LNX.4.21.0210011625330.11146-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



pgsql-odbc by date

Next:From: valcauda St├ęphaneDate: 2002-10-01 14:47:26
Subject: Fw: [Novice]
Previous:From: valcauda St├ęphaneDate: 2002-10-01 14:21:45
Subject: [NOVICE] GUI Interface

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