Subject | How to detect a read only transaction in SP? |
---|---|
Author | Bjoern Reimer |
Post date | 2005-04-24T09:26:11Z |
I'm to sure wether this is a firebird or a IBO question. But I
think Helen know the answer and shes on both lists :-)
I'm using the read only property of TIB_transaction.
The help file says only:
"Makes this transaction ReadOnly at the API level."
My Question: How can I detect in an SP (or Trigger) that the
transaction is ReadOnly? I only have the current_transaction
in FB 1.5 but I can't find a way to see whether its a
ReadOnly transaction or not.
My idea is to have a code snippet in the log sub sp like
if (current_transaction IS NOT readonly) then
<Insert into Log-Table>
Bjoern
--
SOFTbaer --- reimer@... --- www.softbaer.de
think Helen know the answer and shes on both lists :-)
I'm using the read only property of TIB_transaction.
The help file says only:
"Makes this transaction ReadOnly at the API level."
My Question: How can I detect in an SP (or Trigger) that the
transaction is ReadOnly? I only have the current_transaction
in FB 1.5 but I can't find a way to see whether its a
ReadOnly transaction or not.
My idea is to have a code snippet in the log sub sp like
if (current_transaction IS NOT readonly) then
<Insert into Log-Table>
Bjoern
--
SOFTbaer --- reimer@... --- www.softbaer.de