odbc_foreignkeys
("Note: If auto-commit is disabled (see odbc_autocommit()) and you call odbc_free_result() before committing, all pending transactions are rolled back.")
I've looked thru the code, and that note is definitely wrong, at least in my environment (Windows/SQL Server). odbc_free_result ultimately just calls SQLFreeStmt which has NO EFFECT on outstanding transactions.
In fact, it seems it must be wrong for all environments, because the SQLFreeStmt is bound to the destruction of the result resource. So unset($result) would be just as dangerous - and you're randomly and unpredictably screwed if garbage collection reaps the result set before your transaction's done.
odbc_free_result
(PHP 4, PHP 5)
odbc_free_result — recursos libres asociados con un resultado
Descripcion
int odbc_free_result
( int $result_id
)
Always returns TRUE.
odbc_free_result() solo necesita ser llamado en caso de preocupacion por demasiado uso de memoria cuando se ejecuta un script. Toda la memoria resultante quedara automaticamente liberada cuando el script finalice. Pero si es seguro que no se vaya a necesitar la informacion nada mas que en un script, se debera llamar a la funcion odbc_free_result(), y la memoria asociada con result_id sera liberada.
Note: Si la auto-entrega no esta activada la (ver odbc_autocommit()) y se ejecuta odbc_free_result() antes de la entrega, todo queda pendiente de las transaciones que esten en lista.
add a note
User Contributed Notesodbc_free_result
rich at kastle dot com
20-Dec-2004 12:48
20-Dec-2004 12:48
rogersd at island dot net
06-Sep-2001 05:03
06-Sep-2001 05:03
odbc_free_result() is also the way to avoid the dreaded "Too many open cursor" error.