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
