Subject How to detect a read only transaction in SP?
Author Bjoern Reimer
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