Page 1 of 1

ibcQuery, ibcSQL with ReadOnly Transaction

Posted: Sun 03 Apr 2016 13:31
by VICcus
Hi!

In generally I change the ibcTransactions params from ReadCommited to ReadOnlyReadCommited in my application for ibcQuery and ibcSQL.

If the sql contain insert / update, its not a readonly query. Ok.
But what's happen, when the sql contain DML statement, such as Alter Table, Set Statistics, ... ?

Thanks in advance.

Re: ibcQuery, ibcSQL with ReadOnly Transaction

Posted: Sun 03 Apr 2016 14:14
by VICcus
Correction: DDL of course.

Re: ibcQuery, ibcSQL with ReadOnly Transaction

Posted: Tue 05 Apr 2016 09:54
by ViktorV
On attempt to execute DDL statements within the context of ReadOnlyReadCommited transaction, an error "attempted update during read-only transaction" will be generated.

Re: ibcQuery, ibcSQL with ReadOnly Transaction

Posted: Tue 05 Apr 2016 13:16
by VICcus
OK, thanks.

Re: ibcQuery, ibcSQL with ReadOnly Transaction

Posted: Wed 06 Apr 2016 05:35
by ViktorV
If you have any questions during using our products, please don't hesitate to contact us - and we will try to help you solve them.