----- Original Message -----
From: "Thomas Chabaud" <tc@xxxxxxxxxx>
To: <pgsql-odbc@xxxxxxxxxxxxxx>
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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
|
