>>>>How can this code:
>>>>
>>>>IF RLOCK()
>>>>REPLACE DateComp WITH DATE()
>>>>ENDIF
>>>>
>>>>cause this error:
>>>>
>>>>"Record is in use by another"
>>>>
>>>>the line that causes the error is the line with the REPLACE on it. I thought
>>>>that if RLOCK() is true, then no-one else can possibly have the record open.
>>>>
>>>>What gives?
>>>>
>>>>Thanks in advance
>>>
>>>Are you opening the table in more than one area?
>>>
>>>What is your multilocks setting?
>>
>>>Are you opening the table in more than one area?
>>
>>No
>>
>>>What is your multilocks setting?
>>
>>On
>>
>>
>>Does that help?
>
>
>I believe someone else had a similar error but had the same table open in more than one area. But I can't duplicate this error. If you cut out just that snippet of code and run it does it generate the same error?
I haven't tried that (yet). The error doesn't occur consistently.
The system is for conducting surveys and each phoner is supposed to get the
next available phone number. I stuff the DateComp field with DATE() before displaying
the phone number and I test for DateComp <> DATE() to determine if a record is
available or not. What's happening is that two phoners are sometimes getting the
same phone number.
I know that this doesn't help much, I'll try to duplicate the problem on a smaller
scale.
Thanks
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only