<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
So for TIBQuery and TIBSQL should I be doing anything when using select
statements to ensure that the transaction is read only or is it only an
issue when using tables? I don't know what you mean by "mark the
transaction inside the query appropriately" since there are no
properties for specifying a transaction as read only.<br>
<br>
Phil.<br>
<br>
Rohit Gupta wrote:
<blockquote cite="mid42E8BADF.30533.AAE0E07@localhost" type="cite">
<pre wrap="">A readonly table is RO for the end user but not as far as the Firebird
is concerned. It looks at the transaction type. You can do a select
with a normal default transaction that IBO or IBX or whatever put
on. This is what most people do when they start. But this is not
read only... it leaves the transaction open for edit/insert/delete.
You need to mark the transaction inside the table/query
appropriately. I dont remember the official names as we always use
subclassed components. In these we make the table.readonly do
the right thing. We also rename the IBO's IB_Transaction to
Transaction to make it more component neutral. We also allocate a
new transaction inside it if it has not been assigned by the
programmer. So that it never uses the default transaction.
Date sent: Thu, 28 Jul 2005 10:48:08 +1200
From: Phil Middlemiss <a class="moz-txt-link-rfc2396E" href="mailto:phil@tumonz.co.nz"><phil@tumonz.co.nz></a>
Organization: MTS Ltd
To: NZ Borland Developers Group - Delphi List <a class="moz-txt-link-rfc2396E" href="mailto:delphi@ns3.123.co.nz"><delphi@ns3.123.co.nz></a>
Subject: Re: [DUG] Firebird connections / queries / transactions
Send reply to: NZ Borland Developers Group - Delphi List <a class="moz-txt-link-rfc2396E" href="mailto:delphi@ns3.123.co.nz"><delphi@ns3.123.co.nz></a>
<a class="moz-txt-link-rfc2396E" href="mailto:delphi-request@ns3.123.co.nz?subject=unsubscribe"><mailto:delphi-request@ns3.123.co.nz?subject=unsubscribe></a>
<a class="moz-txt-link-rfc2396E" href="mailto:delphi-request@ns3.123.co.nz?subject=subscribe"><mailto:delphi-request@ns3.123.co.nz?subject=subscribe></a>
[ Double-click this line for list subscription options ]
Thanks for the overview. By "read-only" transactions, are you referring
to the SQL executed within a transaction? Your comment about the default
transaction not being read-only has me puzzled - isn't it the table
itself that is readonly?
Phil.
Rohit Gupta wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Readonly transactions do not contribute to this problem. Note that
both the table/query and the transaction has to be readonly.
WARNING - Do not use the default transaction as it is not readonly
and was the cause of our problems.
</pre>
</blockquote>
<pre wrap=""><!---->_______________________________________________
Delphi mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Delphi@ns3.123.co.nz">Delphi@ns3.123.co.nz</a>
<a class="moz-txt-link-freetext" href="http://ns3.123.co.nz/mailman/listinfo/delphi">http://ns3.123.co.nz/mailman/listinfo/delphi</a>
Regards
Rohit
======================================================================
CFL - Computer Fanatics Ltd. 21 Barry's Point Road, AKL, New Zealand
PH (649) 489-2280
FX (649) 489-2290
email <a class="moz-txt-link-abbreviated" href="mailto:rohit@cfl.co.nz">rohit@cfl.co.nz</a> or <a class="moz-txt-link-abbreviated" href="mailto:r.gupta@xtra.co.nz">r.gupta@xtra.co.nz</a>
======================================================================
_______________________________________________
Delphi mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Delphi@ns3.123.co.nz">Delphi@ns3.123.co.nz</a>
<a class="moz-txt-link-freetext" href="http://ns3.123.co.nz/mailman/listinfo/delphi">http://ns3.123.co.nz/mailman/listinfo/delphi</a>
</pre>
</blockquote>
</body>
</html>