[DUG] Firebird connections / queries / transactions

[Phil Middlemiss]

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 <phil at tumonz.co.nz>
>Organization:   	MTS Ltd
>To:             	rohit at cfl.co.nz,
>  	NZ Borland Developers Group - Delphi List <delphi at ns3.123.co.nz>
>Subject:        	Re: [DUG] Firebird connections / queries / transactions
>Send reply to:  	phil at tumonz.co.nz
>
>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.
>
>  
>