>>>>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement