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