| 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: | Whole Thread | Raw Message | 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 |