Re: help - psqlODBC with V5 - Mailing list pgsql-odbc

From Corey W. Gibbs
Subject Re: help - psqlODBC with V5
Date
Msg-id 01C213AE.61B95B90.cgibbs@westmarkproducts.com
Whole thread Raw
In response to help - psqlODBC with V5  ("Robson Martins" <robson-martins@bol.com.br>)
List 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@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 >>

pgsql-odbc by date:

Previous
From: "Robson Martins"
Date:
Subject: help - psqlODBC with V5
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] KSQO parameter