Thread: Move Previous

Move Previous

From
"Ryan C. Bonham"
Date:
Hi,

Ok this might not have anything to do with the ODBC Driver, but right now I
haven't figured out what else would cause it.

I have a VB 6.0 App. I was using ODBC 7.01.0006. I had problems with Boolean
fields being reported back correctly, I updated to 7.01.0007 and that
problem went away. Now though, all my rs.RecordCount statements report -1..
Also I am having some issues with rs.MovePrevious reporting "Operation not
allowed in this context", but that is only happening on certain tables.. I
tried changing the cursor type(I have used keyset/dynamic/static), and it
reports the same problems.. The MovePrevious might be something silly I did,
but the record count was working until I updated the driver.. Does anyone
have any ideas..

Ryan C. Bonham
System Administrator
Summit Ridge Farms
Phone: (570)-756-2656
Fax: (570)-756-2826

Re: Move Previous

From
"Ryan C. Bonham"
Date:
Nevermind,

I figured it out, i had the declare/fetch option checked... Sorry for
wasting everyones time..


Ryan

> -----Original Message-----
> From: Ryan C. Bonham [mailto:Ryan@srfarms.com]
> Sent: Tuesday, October 02, 2001 11:38 AM
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] Move Previous
>
>
> Hi,
>
> Ok this might not have anything to do with the ODBC Driver,
> but right now I
> haven't figured out what else would cause it.
>
> I have a VB 6.0 App. I was using ODBC 7.01.0006. I had
> problems with Boolean
> fields being reported back correctly, I updated to 7.01.0007 and that
> problem went away. Now though, all my rs.RecordCount
> statements report -1..
> Also I am having some issues with rs.MovePrevious reporting
> "Operation not
> allowed in this context", but that is only happening on
> certain tables.. I
> tried changing the cursor type(I have used
> keyset/dynamic/static), and it
> reports the same problems.. The MovePrevious might be
> something silly I did,
> but the record count was working until I updated the driver..
> Does anyone
> have any ideas..
>
> Ryan C. Bonham
> System Administrator
> Summit Ridge Farms
> Phone: (570)-756-2656
> Fax: (570)-756-2826
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>