Subject Re: [firebird-support] select with lock
Author Serg Vostrikov
Dear L.M.,

Thursday, July 24, 2003, 11:16:46 AM, you wrote:

LMB> FB 1.5 has a new feature select * from table with lock

LMB> Could someone explain to me how this works.
LMB> 1.is it a kind of record locking (if your where clause collects only 1
LMB> record ) ?
LMB> 2.does it lock all fields in the where clause or complete records
LMB> 2.how long are records locked ? until post or until commit ?
LMB> 3.is it an alternative for thoe old recordlocking ?

Read the new article of Alexander Nevsky and Alex Cherednichenko "How
to lock a record in InterBase/Firebird" on InterBase World:

http://www.interbase-world.com/modules.php?name=News&file=article&sid=423

I'm sure it will be helpful.


--
Sincerely yours,
Serg

Devrace - software for developers!
__________________________________
e-mail: sv@...
url : http://www.devrace.com/, http://www.devrace.de/
http://www.fibplus.net/, http://www.athlant.com/