From:             [EMAIL PROTECTED]
Operating system: WinNT4.0 SP6
PHP version:      4.0.6
PHP Bug Type:     ODBC related
Bug description:  odbc_fetch_row uses update cursor on ODBC cursor library

First off: there is no need to. A read-only cursor would do just fine on a
PHP. On a PHP-script it is impossible to update any data via a open
cursor.

This would avoid the infamous
SL002: Positioned request could not be performed because result set was
created by a join condition.

The error can be reproduced by simply executing a SQL-clause with a join in
it on a MS SQL 7.x or greater. Joins on a MS SQL (or Sybase) are not
updateable so a read-only cursor is required.

Also it would be nice to warn users that odbc_fetch_into
cannot be used to retrieve any data selected with a join.
-- 
Edit bug report at: http://bugs.php.net/?id=13152&edit=1


-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to