Re: [Firebird-net-provider] Read allowed despite locking table in transaction

2015-07-21 Thread Jiří Činčura
Don’t do that. Database engine (any) people do a great effort to reach maximum throughput and you want to limit it to basically 1. If you need someething like that, your design has serious flaw. -- Mgr. Jiří Činčura Independent IT Specialist From: LtColRDSChauhan [mailto:rdsc1...@gmail.com] Sen

[Firebird-net-provider] Read allowed despite locking table in transaction

2015-07-21 Thread LtColRDSChauhan
Hello, Earlier, by mistake I sent an incomplete mail on this issue. Apologies for the same. 1. I want to lock a table then : (a) read a record from this table and then (b) write a record to this table. 2. While I do the above, I want to disallow read and write to this table. 3. The b