From: | "Corey W(dot) Gibbs" <cgibbs(at)westmarkproducts(dot)com> |
---|---|
To: | "'Robson Martins'" <robson-martins(at)bol(dot)com(dot)br>, "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: help - psqlODBC with V5 |
Date: | 2002-06-14 21:18:39 |
Message-ID: | 01C213AE.61B95B90.cgibbs@westmarkproducts.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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(at)bol(dot)com(dot)br]
Sent: Thursday, June 13, 2002 7:52 AM
To: pgsql-odbc(at)postgresql(dot)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 >>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-06-16 00:08:35 | Re: [HACKERS] KSQO parameter |
Previous Message | Michael R. Anderson | 2002-06-14 15:21:51 | odbc connection stays read-only |