C
chrisjr
Guest
So I just tried updating the record in the FOR block and Fernando was correct, the lock is downgraded. So, this example works as I would expect it to: for first mytable exclusive-lock: mytable.myfield = mytable.myfield + "123". message "0 " transaction view-as alert-box. end. message "1 " available mytable transaction view-as alert-box. Just another example, I can also reproduce this bug with a FOR EACH that includes a LEAVE. The following example will cause the EXCLUSIVE-LOCK to be retained after the FOR block (although adding an actual update in this case also resolves the issue): for each mytable exclusive-lock: message "0 " transaction view-as alert-box. leave. end. message "1 " available mytable transaction view-as alert-box.
Continue reading...
Continue reading...