Thread: help - psqlODBC with V5
I'am usage VB 5.0 with PostgrSQL 7.1.3 and postODBC driver 7.2.1, while use psqlODBC driver 7.01.0009, not error,
because?
Message erros is:
Erro 40008 - Invalid operation for forward-only cursor ( error, only version driver psqlODBC 7.2.1)
thank's.
Robson Martins
from Brazil
Howdy Robson, I think you want to try the adOpenKeyset option on the recordset object. That lets you go forward and backwards in the recordset. I went around and around with this for a while. Hope this helps corey dim rs as new adodbc.recordset set rs = new adodbc.recordset rs.Open "SELECT * from foo WHERE bar='VBisFun:P'", cn, adOpenKeyset, adLockOptimistic -----Original Message----- From: Robson Martins [SMTP:robson-martins@bol.com.br] Sent: Thursday, June 13, 2002 7:52 AM To: pgsql-odbc@postgresql.org Subject: [ODBC] help - psqlODBC with V5 I'am usage VB 5.0 with PostgrSQL 7.1.3 and postODBC driver 7.2.1, while use psqlODBC driver 7.01.0009, not error, because? Message erros is: Erro 40008 - Invalid operation for forward-only cursor ( error, only version driver psqlODBC 7.2.1) thank's. Robson Martins from Brazil << File: ATT00026.htm >>