Re: [firebird-support] read-only select generates 'lock conflict on no wait transaction'?

2014-09-19 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Thu, Sep 18, 2014 at 1:00 PM, 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] wrote: > > > If you are sure that there will be no data editing, I recommend you to use > ReadCommited+ReadOnly transaction, since it will not block garbage > collection. > > Assuming you can live with a

Re: [firebird-support] read-only select generates 'lock conflict on no wait transaction'?

2014-09-18 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]

Re: [firebird-support] read-only select generates 'lock conflict on no wait transaction'?

2014-09-18 Thread av...@telusplanet.net [firebird-support]
thanks for the quick reply i'll create another IBOTransaction and use it for the one query that is doing the 'read-only' simple select that is resulting in the error. would you expect that error to occur every time a 2nd user does a readonly select that includes the 1st users record in edi

Re: [firebird-support] read-only select generates 'lock conflict on no wait transaction'?

2014-09-18 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]

[firebird-support] read-only select generates 'lock conflict on no wait transaction'?

2014-09-18 Thread av...@telusplanet.net [firebird-support]
Hi-- I've got a FB 2.5 app that uses IBO components and Delphi The instance has perhaps 40 concurrent users. Someone would potentially have a record in 'edit' mode. Another user does a read-only (tIBOQuery.RequestLive := False) select from the same table. Not always, but once i