Simon Carter wrote:

> Hi all,
>
> I am slowly getting to grips with ibase_* API in PHP. However I am a little
> stuck on how to specify a transaction resource to a execute/query function.
> I have looked at:
>
> http://uk2.php.net/manual/en/function.ibase-query.php
> http://uk2.php.net/manual/en/function.ibase-execute.php
>
> And neither one of these requires (as far as I can tell) the transaction as
> a parameter. Am I missing the obvious somewhere?

pass the transaction id iso the dbconnection id as the first arg to
ibase_query() and ibase_prepare()

>
> FYI what I am attempting to do is:
>
> Start connection.
> Start read only tran
> Read a bunch of records
> Start r/w tran
> Update record
> Commit r/w tran
> Start r/w tran
> Update record
> Commit r/w tran
> Rollback read only tran
> Close connection
>
> Which is why I was looking for a way to specify which transaction is
> associated with which query/execute method.
>
> Rgds
>
> Si Carter
> http://www.fbtalk.net/
> http://www.tectsoft.net/
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>