tomsee7 wrote:

> Just FYI Lester the app is a Command Line Interface (CLI) app here (although there is web interface to it too).

I'd still be interested to know that the connection IS being opened and closed
properly. I WAS having this very problem with my own web applications. I manage
the database via Flamerobin, and often add to or edit the control tables
'manually', but the web users where not seeing the new records. It turned out to
be a combination of caching and transactions, so now I always open and close my
own transactions. I'm not convinced that the php_interbase driver DOES follow
the same rules as the abstraction layers expect. Certainly the 'default'
transaction setup is not idea so I always override IBASE_DEFAULT. Auto-commit is
not a default in php_interbase, or at least that is my understanding, but ZendX
may simply be expecting it to happen.

--
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