masotti wrote:

> Try to explain better:
>
> masotti ha scritto:
>> Lester Caine ha scritto:
>>
>>> But how do people handle holding a transaction open -
>>> CAN we in PHP?
>>>
>>>
>>>
>> AFAIK no. Transaction are closed (committed or rollback) at the end of
>> the script. Docs are clear about that.
>> Workaround are:
>> 1) Temporary tables (connection persistence)
>> 2) $_SESSION superglobal
>> Don't know other methods.
>>
> In the sense yhat you (as I actually do) must retain all data in php
> structures (or not transactional data), and commit all in a single phase
> at the end,only when thibgs are all prepared and user clicks "CONFIRM".
> If the user chosses an other path, data are erased (partially or
> globally), and restarts from a well known point.

That is where I thought we were at ;)
But perhaps it is something that we could look at if we are to improve
the driver.
Persistent transactions to go with persistent connections.

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/lsces/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