Jiri Cincura wrote:

> On Mon, Dec 20, 2010 at 23:06, Lester Caine<lester@...> wrote:
>> There are a few bits on the core driver which really need readdressing and this
>> is probably the key one. The only way around it IS to start an explicit
>> transaction as soon as the connection opens. All of my stuff is done with ADOdb,
>
> But that means also adding transaction link to all fbird_query calls
> and later committing the transaction, right?

You just use the 'transaction' handle rather than the connection handle in the
call, but yes you do then have to commit since the default would be a rollback.

http://www.janus-software.com/fbmanual/manual.php?book=php&topic=25 is wrong!
It would be nice if php manual had the fbird_ aliases
http://www.php.net/manual/en/function.ibase-query.php - $link_identifier is
either the connection, or the transaction handle. This also allows the two phase
commit transactions to be handled ... something PDO is not capable of.

ADOdb just selects the right handle when running the native functions, and also
handles the autocommit manually.

>> so it's just a matter of 'adjusting' the way that works.
>>
>> I think we do need to take a closer look at php_interbase, and perhaps now is
>> the time to start running our own php_firebird build?
>
> I think so.

Not sure of the best way of handling this, but I think it is about time that a
firebird install on PHP actually worked with the right client and we start
adding firebird specific support.

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