ingres_commit

Commit a transaction (PHP 4 >= 4.0.2, PHP 5 <= 5.0.5, PECL ingres:1.0-1.4.3)
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.

Code Examples / Notes » ingres_commit

burckhardtnospam

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.

Change Language

ingres_autocommit
ingres_close
ingres_commit
ingres_connect
ingres_cursor
ingres_errno
ingres_error
ingres_errsqlstate
ingres_fetch_array
ingres_fetch_object
ingres_fetch_row
ingres_field_length
ingres_field_name
ingres_field_nullable
ingres_field_precision
ingres_field_scale
ingres_field_type
ingres_num_fields
ingres_num_rows
ingres_pconnect
ingres_query
ingres_rollback