Subject Re: [firebird-php] Enclosing SENTENCES in one transaction
Author Lester Caine
JJHERMOSILLO wrote:

> Hi people, i'm using Firebird 1.5.2.
>
> I need to enclose some setentces in one transaction.
>
> Example.
>
> Start Transaction
> Select
> Update
> Delete
> Insert
> Call a StoreProcedure
> If No Errors Then Commit Else RollBack.
>
> I haven't found information abot how to do these things in FireBird.
>
> I know that FireBird has the auto commit mode by default.
>
> Does Any Body knows How can i do that kind of thins using FireBird?
> What kind of instructions should i use ?
>
> Thanks A Lot Guys :D

Well since you are asking on the PHP support list - how about
http://uk2.php.net/manual/en/ref.ibase.php

http://uk2.php.net/manual/en/function.ibase-trans.php
http://uk2.php.net/manual/en/function.ibase-query.php
http://uk2.php.net/manual/en/function.ibase-commit.php

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services