Hi,

I don't know since I never used PEAR.
The code was only intended as an example to demonstrate how to use
separate transactions per request.
If PEAR allows the use of transactions with interbase/firebird, you
shold be fine.

/thomas

Almond wrote:

> Thank you for you reply. Is the code work on PEAR ?
>
> Best regards,
>
> Almond Wong
>
> At 14:50 03/11/13 +0100, you wrote:
>
>>Hi.
>>
>>This is because of the PHP default transaction, which is automatically
>>committed or rolled back on script termination.
>>
>>Just use single transactions for your queries, that should do the trick,
>> so like:
>>
>>$tr = ibase_trans(IBASE_COMMITTED, $conn);
>>ibase_execute($tr, "SOMETHING WITH YOUR SP");
>>ibase_commit($tr);
>>
>>$tr = ibase_trans(IBASE_READ, $conn);
>>ibase_execute($tr, "SELECT STUFF");
>>ibase_commit($tr);
>>
>>Hope that helps.
>>
>>Thomas
>>
>>Almond wrote:
>>
>>>Hello all.
>>>
>>>I insert a record through a "execute procedure" query in PHP, and I found
>>>that the new inserted
>>>record cannot be retrieved until I execute a "commit" through isql.
>>>
>>>Is that I can force the write in a stored procedure ?
>>>
>>>Best regards,
>>>
>>>Almond Wong
>>>
>>>
>>>
>>>To unsubscribe from this group, send an email to:
>>>firebird-php-unsubscribe@yahoogroups.com
>>>
>>>
>>>
>>>Your use of Yahoo! Groups is subject to
>>
>><http://docs.yahoo.com/info/terms/>http://docs.yahoo.com/info/terms/
>>
>>>
>>
>>Yahoo! Groups Sponsor
>><http://rd.yahoo.com/SIG=12cc140pi/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/EXP=1068818073/A=1524963/R=0/*http://hits.411web.com/cgi-bin/autoredir?camp=556&lineid=3614674&prop=egroupweb&pos=HM>ebf3565.jpg
>>
>>ebf35fb.jpg
>>
>>To unsubscribe from this group, send an email to:
>>firebird-php-unsubscribe@yahoogroups.com
>>
>>
>>
>>Your use of Yahoo! Groups is subject to the
>><http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-php-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>