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> 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> long are records locked ? until post or until commit ?
LMB> 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:

I'm sure it will be helpful.

Sincerely yours,

Devrace - software for developers!
e-mail: sv@...
url :,,