OK, thanks. I'll try to find out.
Phil.
Rohit Gupta wrote:
Phil,
I dont use TIB components. I see that they have a transaction
property but no ReadOnly property. There are only four choices
which is not enough. The answer is I dont know. IBO has Isolation
and ReadOnly properties. The transaction property wrt the Firebird
actually has some 20 different options which IBO makes up from
various exposed properties..
You will have to ask someone else. I guess the following might
reveal it.
Connect the table to a grid, execute a select statement. change
the property to readonly at runtime - if it rereads the data then it
may be doing the right thing. But if it does not refetch the data then
it is not working correctly.
I do remember reading that the concept of default transaction
came from Borland... so I wouldnt use it.
Date sent: Thu, 28 Jul 2005 11:18:04 +1200
From: Phil Middlemiss <[EMAIL PROTECTED]>
Organization: MTS Ltd
To: [EMAIL PROTECTED],
NZ Borland Developers Group - Delphi List <[email protected]>
Subject: Re: [DUG] Firebird connections / queries / transactions
Send reply to: [EMAIL PROTECTED]
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.
Phil.
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
