Try setting the use manager cursors in the MyODBC panel for the database in
question.
Pat...
[EMAIL PROTECTED]
----- Original Message -----
From: "Uwe Hein" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
>
>
>
>
>
> Uwe Hein Folkwang Musikschule der Stadt Essen / Germany
> Voca Ruhrpott --------- Thu, 08 Mar 2001 19:33 +0100
> Email: [EMAIL PROTECTED]
>
>
>
>
> ---------------------------------------------------------------------
> 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 <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> 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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
