I am reposting this topic because after I corrected my typo, I still encountered a serious problem.
I am having trouble making a simple assignment to a field with a procedure in a shared database.
When I have this code in a procedure
Find [search criteria] [Fieldname]=[some value]
it does nothing; seemingly ignored. The procedure stops when it encounters the assignment statement. If I run this code in a separate procedure, I see a message in the procedure window;
“Cannot modify field [Fieldname], record is locked by another user.” [That cannot possibly be true in this instance.]
I tried locking the record, then making the assignment, then unlocking it. That did not work. It gives a message that the record is locked by another user. I don’t know why the record would have been locked at all before trying to make the assignment. The Server Admin does not show a locked record, before, during, or after the procedure runs and nothing in the procedure, as I understand it, has locked the record.
It seems like the Find statement locked the record that it found but it was not associated with me, so I couldn’t change it.