--- In firebird-php@yahoogroups.com, "u.masotti@..." <u.masotti@...> wrote:

>
> Hi Tom,check your code, because PHP 5.+ explicitly activeted transactions need to be committed otherwise at the end of the script are rolled back.Only implicit transaction (i.e. without using ibase_trans) are committed.
> Ciao.Mimmo.
>
>
>
> ----Messaggio originale----
>
> Da: tomconlon7@...
>
> ibase_trans(IBASE_DEFAULT, $this->_connection) to
>
> ibase_trans( IBASE_WRITE|IBASE_COMMITTED|IBASE_WAIT, $this->_connection) but no difference.
>
> [Non-text portions of this message have been removed]
>

Thanks for the reply Mimmo & Lester,

I've just double-checked this and it certainly seems to be committing as the app deletes rows and the table is empty (as expected) when exiting the app.

When I externally re-insert test records during the process it shows up in ibxexpert and flamerobin but the php process still doesn't see them. :(

In addition, according to the ZF documentation: "By default, all Zend_Db Adapter classes operate in auto-commit mode".

I'm now also opening and closing connections explicitly at beginning at end of each distinct period of work but still same.
Tom