tomsee7 wrote:

> I'm running a php windows service and it opens a connection, selects records, does some stuff, the closes the connection until it runs again later.
>
> The first run all's good but subsequent times no records are visible even though different fb client tools (ibexpert& flamerobin) can see the new records.
>
> Points to note:
> 1. The ZendX_Db_Adapter_Firebird appears to use the php_interbase extension.
> 2. Tried changing _beginTransaction() key line:
> ibase_trans(IBASE_DEFAULT, $this->_connection) to
> ibase_trans( IBASE_WRITE|IBASE_COMMITTED|IBASE_WAIT, $this->_connection) but no difference.

If you restart apache/php are the records then visible?
I've never used ZendX_Db_Adapter_Firebird but on other abstraction layers that
pool connections, the connection/transaction can be left open so that subsequent
use of the connection still sees the old transaction view. Not sure how ZendX
handles that, but it is most likely what is happening.

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php