>>>>>>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
>
>I really don't see the use of date() here...
>
>Vlad
Vlad
The DateComp field is used on several reports. Since I capture the date before
displaying the phone number, it also serves (or should serve) the purpose of a
"used record" indicator. Records with dates are not available to other users.
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