Re: Annoying problem with UseDeclareFetch

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

Salut
Andi Gunawan