Subject Pessimistic Locking / Events
Author Alan McDonald
I am going to use the WITH LOCK clause for a one record select (in 1.5.2).
I wonder if anyone knows an easy way for me to select a larger set of
records which includes the single rows which have the WITH LOCK applied,
where I can tell at the client side which rows in the larger set have the
LOCK current on them.
I intend using events to ensure the client keeps updating this larger (but
still relatively small set) of records, but I would like to display which
ones of the larger set are currently under editing (LOCK) by other users.
Any ideas? - or maybe I need to use a variant of the dummy update method?