Subject | select with lock |
---|---|
Author | L.M. Bemmelmans |
Post date | 2003-07-24T07:16:46Z |
FB 1.5 has a new feature select * from table with lock
Could someone explain to me how this works.
1.is it a kind of record locking (if your where clause collects only 1
record ) ?
2.does it lock all fields in the where clause or complete records
2.how long are records locked ? until post or until commit ?
3.is it an alternative for thoe old recordlocking ?
Leon
Could someone explain to me how this works.
1.is it a kind of record locking (if your where clause collects only 1
record ) ?
2.does it lock all fields in the where clause or complete records
2.how long are records locked ? until post or until commit ?
3.is it an alternative for thoe old recordlocking ?
Leon