Subject | Ibase_query -> specify transaction |
---|---|
Author | Simon Carter |
Post date | 2005-06-13T17:45:44Z |
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?
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/
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?
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/