Hi all,
Can anyone tell me why this program is only allowed one user running at a time?
Does the exclusive-lock apply to a paticular record only or the whole table?
For example, if I enter wo_nbr = "123", another user trying to run the same
program with wo_nbr "345".
It will display "ca_mstr in user by another user....".
I think I should be still able to update a different record.
<BLOCKQUOTE><font size="1" face="Arial, Verdana">code:</font><HR><pre>
mainloop:
repeat:
update wo_nbr with frame a.
find ca_mstr where ca_po_nbr = wo_nbr exclusive-lock no-error.
if not available ca_mstr then do:
bell.
message "Wo number " + wo_nbr + " does not exist".
undo mainloop, retry mainloop.
end.
update ca__chr01 ca__chr02 with frame a.
end.
[/code]
Thanks
Lisa
Can anyone tell me why this program is only allowed one user running at a time?
Does the exclusive-lock apply to a paticular record only or the whole table?
For example, if I enter wo_nbr = "123", another user trying to run the same
program with wo_nbr "345".
It will display "ca_mstr in user by another user....".
I think I should be still able to update a different record.
<BLOCKQUOTE><font size="1" face="Arial, Verdana">code:</font><HR><pre>
mainloop:
repeat:
update wo_nbr with frame a.
find ca_mstr where ca_po_nbr = wo_nbr exclusive-lock no-error.
if not available ca_mstr then do:
bell.
message "Wo number " + wo_nbr + " does not exist".
undo mainloop, retry mainloop.
end.
update ca__chr01 ca__chr02 with frame a.
end.
[/code]
Thanks
Lisa