Hi Thomas, the workaround works fine!
We will also take a look, whether we really need this function or can replace it. Thanks a lot for the help, Thomas "Koetter, Thomas Theodor" <[EMAIL PROTECTED]> on Wed Apr 19 2006 at 16:04 +0100 wrote: >Hello Thomas > >> -----Original Message----- >> From: Thomas Schulz [mailto:[EMAIL PROTECTED] >> Sent: Mittwoch, 19. April 2006 11:48 >> To: maxdb@lists.mysql.com >> Subject: odbc_num_rows via PHP-ODBC returns -1 >> >> Hello, >> >> we are actually migrating from Adabas D 11 to MaxDB 7.6.0.16 >> and are now >> testing the PHP functions via ODBC on Linux (configured PHP 4.4.2 with >> option "with-sapdb=..."). We are using the ODBC version, >> because the new >> maxdb PHP driver don't work and we don't want to change too much. > >Actually, the MaxDB PHP driver should work. If you have problems, which >seem to be bugs, please report how the problems can be reproduced. > >However, using PHP over ODBC is not prohibited ;-) > >> >> Most of the existing ODBC functions seems to work in the same way for >> Adabas and MaxDB, but there are some functions, which doesn't exist >> (odbc_fetch_array) or return wrong values (odbc_num_rows). >> >> Small PHP example for odbc_num_rows: >> $conn = odbc_connect("host:testdb", "testuser", "testpassword"); >> $result = odbc_exec($conn, "select * from testtab"); >> $num_rows = odbc_num_rows($result); >> >> If I fetch the content of all rows, I get them all. But odbc_num_rows >> return always -1! Is there a bug at this function? > >No bug. The number of rows of a result set can not be determined in any >case. Please compare the documentation in the ODBC reference for >SQLRowCount, which is the ODBC-function behind. Actually SQLRowCount is >not meant to count the rows of a result set. In principle this number can >change (depending on the isolation level) during fetching the result set >and is not reliable. > >If you add the appendix "for reuse" to your select statement (select * >from testtab for reuse), the result set is fully built in the kernel an >odbc_num_rows should return the number of *this* result set. > >Maybe this is a work around for you. > > > >With kind regards Thomas > > > > >---------------------------------------------- >Dr. Thomas Kötter >SAP AG, Berlin >NW DT MaxDB > >MaxDB: all you need! >www.mysql.com/products/maxdb www.sapdb.org > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
