Skip site navigation (1) Skip section navigation (2)

Re: Annoying problem with UseDeclareFetch

From: "gunawan" <gunawan(at)ikp(dot)component(dot)astra(dot)co(dot)id>
To: <tc(at)geosys(dot)com>,<pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Annoying problem with UseDeclareFetch
Date: 2005-11-29 10:15:53
Message-ID: 006601c5f4cd$e15feb80$6702a8c0@subfinance (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
----- Original Message ----- 
From: "Thomas Chabaud" <tc(at)geosys(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Sent: Tuesday, November 29, 2005 4:34 PM
Subject: [ODBC] Annoying problem with UseDeclareFetch

| I'm using VB 6.0 with postgreSQL v8.0 and ODBC Driver v8.1.1.
| I have set the driver's option UseDeclareFetch to true in order to avoid
| recordset paging problem, but with this option enabled, rs.RecordCount
| is always equal to -1.
| Is it normal ?
| Is there a way to solve this, because my application makes a lot of
| calls to rs.recordcount ? Another driver option ? Driver version ?

to handle this matter I prefer not to use rs. recorcount, but I use while
... wend so I can get the correct one.
another driver maybe ... should you try pgoledb.
Hope this can solve your problem ...

| Thanks in advance.
| Regards,
| Thomas Chabaud
| ---------------------------(end of broadcast)---------------------------
| TIP 6: explain analyze is your friend

Andi Gunawan

In response to

pgsql-odbc by date

Next:From: AndrusDate: 2005-11-29 13:26:20
Subject: Re: Application crash after error
Previous:From: Thomas ChabaudDate: 2005-11-29 09:34:15
Subject: Annoying problem with UseDeclareFetch

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group