cvs: php4 /ext/odbc php_odbc.c

kalowsky Tue Apr 30 09:17:48 2002 EDT Modified files: /php4/ext/odbc php_odbc.c Log: reverting the cursor change as it seems to break many ODBC drivers. Index: php4/ext/odbc/php_odbc.c diff -u php4/ext/odbc/php_odbc.c:1.125 php4/ext/odbc/php_odbc.c:1.126 --- php4/ext/odbc/php_odbc.c:1.125 Fri Apr 26 10:56:34 2002 +++ php4/ext/odbc/php_odbc.c Tue Apr 30 09:17:48 2002 @@ -20,7 +20,7 @@ +----------------------------------------------------------------------+ */ -/* $Id: php_odbc.c,v 1.125 2002/04/26 14:56:34 kalowsky Exp $ */ +/* $Id: php_odbc.c,v 1.126 2002/04/30 13:17:48 kalowsky Exp $ */ #ifdef HAVE_CONFIG_H #include "config.h" @@ -810,7 +810,7 @@ /* Try to set CURSOR_TYPE to dynamic. Driver will replace this with other type if not possible. */ - if (SQLSetStmtOption(result->stmt, SQL_CURSOR_TYPE, SQL_CURSOR_FORWARD_ONLY) + if (SQLSetStmtOption(result->stmt, SQL_CURSOR_TYPE, SQL_CURSOR_DYNAMIC) == SQL_ERROR) { odbc_sql_error(conn, result->stmt, " SQLSetStmtOption"); SQLFreeStmt(result->stmt, SQL_DROP); @@ -1171,7 +1171,7 @@ /* Try to set CURSOR_TYPE to dynamic. Driver will replace this with other type if not possible. */ - if (SQLSetStmtOption(result->stmt, SQL_CURSOR_TYPE, SQL_CURSOR_FORWARD_ONLY) + if (SQLSetStmtOption(result->stmt, SQL_CURSOR_TYPE, SQL_CURSOR_DYNAMIC) == SQL_ERROR) { odbc_sql_error(conn, result->stmt, " SQLSetStmtOption"); SQLFreeStmt(result->stmt, SQL_DROP);