Hi,
this might be obvious for the more enlightened among us, alas, I had to learn it the hard way (and I hope my interpretation is right):
WHENEVER you use ingres_commit(), you cannot use any other ingres-commands for this connection anymore, since ingres_commit() closes it. That means that any ingres_fetch_row/object/whatever has to come before the ingres_commit-call. I first thought, each ingres_query() had to be "committed", but that was wrong.
ingres_commit
(PHP 4 >= 4.0.2, PHP 5 <= 5.0.5, PECL ingres:1.0-1.4.3)
ingres_commit — Commit a transaction
Description
bool ingres_commit
([ resource $link
] )
ingres_commit() commits the currently open transaction, making all changes made to the database permanent.
This closes the transaction. A new one can be open by sending a query with ingres_query().
You can also have the server commit automatically after every query by calling ingres_autocommit() before opening the transaction.
Parameters
- link
-
The connection link identifier. If not specified, the last opened link is used.
Return Values
Returns TRUE on success or FALSE on failure.
ingres_commit
burckhardtNOSPAM at CUTMEgsf dot de
23-Jan-2002 10:00
23-Jan-2002 10:00
