#30687 [Opn->Fbk]: Second read attempt on memo (LONGCHAR) fields via ODBC fails

ID: 30687 Updated by: sniper@php.net Reported By: albin at kth dot se -Status: Open +Status: Feedback Bug Type: ODBC related Operating System: Windows XP Pro SP2 PHP Version: 5CVS-2004-11-04 (dev) New Comment: Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip Previous Comments: ------------------------------------------------------------------------ [2004-11-04 17:44:13] albin at kth dot se Description: ------------ There seems to be a problem reading Memo-fields (ODBC-type LONGCHAR) from an MS-Access database via ODBC... The first attempt is successfull, but if you try to read the same field again from the same result-set you get nothing. Reading non-memo-fields multiple times works OK. Reproduce code: --------------- $db = odbc_connect('DATABASE','XXXX','XXXX'); $res = odbc_exec($db, "SELECT Body FROM Letters WHERE LetterID = X"); echo "First attempt: ".odbc_result($res, 'Body'); // displays the letter body echo "Second attempt: ".odbc_result($res,'Body'); // displays nothing Expected result: ---------------- First attempt: [Letter body] Second attempt: [Letter body] Actual result: -------------- First attempt: [Letter body] Second attempt: ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=30687&edit=1