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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-odbc by date

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