Subject | Re: [firebird-support] select with lock |
---|---|
Author | Serg Vostrikov |
Post date | 2003-07-24T14:42:18Z |
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/
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/