Re: Bug in MyODBC 2.50.36-nt ??

["Pat Sherrill" <patrick@xxxxxxxxxxx>]

Try setting the use manager cursors in the MyODBC panel for the database in
question.
Pat...
patrick@xxxxxxxxxxx

----- Original Message -----
From: "Uwe Hein" <uwe.hein@xxxxxxxxxxx>
To: <mysql@xxxxxxxxxxxxxxx>
Sent: Thursday, March 08, 2001 2:17 PM
Subject: Bug in MyODBC 2.50.36-nt ??


>
> Hi everybody,
>
> I am using a MySQL Database with MyOdbc 2.50.36-nt under WinNt SP6a and
Win
> 2000 SP 1. The language of my frontend is CA Visual Objects (ClassMate
library
> for SQL)
>
>   When skipping through my data set with
>
> nRetCode =
SQLExtendedFetch(HStatement,SQL_FETCH_NEXT,0,@nNumRows,@nRowStatus)
>
> the function returns 100 (SQL_NO_DATA), when I try to skip beyond EOF of
my
> dataset.
>
> Doing the opposite with
>
> nRetCode
=SQLExtendedFetch(HStatement,SQL_FETCH_PRIOR,0,@nNumRows,@nRowStatus)
>
> I never get nRetCode = 100 when going beyond BOF.
>
>
> Trying the same with the Visual FoxPro (6.0) ODBC driver or MS SQL 7, I
get
> nRetcode = 100 as expected in both cases (going beyond EOF and BOF).
>
> As I am rather new to MySQL, I do not know, if this is really a bug.
Perhaps
> someone could tell me another way how to determine, that I reached the top
of
> my result set.
>
>    regards
>
>      Uwe
>
> Uwe Hein  Folkwang Musikschule der Stadt Essen / Germany
>    Voca Ruhrpott  ---------   Sun, 04 Mar 2001 23:20 +0100
>       Email: uwe.hein@xxxxxxxxxxx
>
>
>
>
>
> Uwe Hein  Folkwang Musikschule der Stadt Essen / Germany
>    Voca Ruhrpott  ---------   Thu, 08 Mar 2001 19:33 +0100
>       Email: uwe.hein@xxxxxxxxxxx
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread67705@xxxxxxxxxxxxxxx>
> To unsubscribe, e-mail
<mysql-unsubscribe-patrick=coconet.com@xxxxxxxxxxxxxxx>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread67769@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php