Re: help - psqlODBC with V5

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 >>

Browse pgsql-odbc by date

  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