Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ISRLOCKED(), Reference Integrity Store Procedure and mor
Message
From
02/10/1997 18:28:37
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00052816
Message ID:
00052957
Views:
33
Jim,

From a bit of a "discussion" on this several months back on the MS VFP group, I *know* that what you have written is true and correct.

*BUT* that is *NOT* what the documentation says and, to make it worse, the "queen" of that very group stated that she had personally brought this to the attention of the folks that matter during BETA (VFP 3, I think she said) and yet it remains the same!

Missing info, incomplete info, misleading info. Wonder why I say the docs need VAST improvement????

Cheers,
Jim N

>>Hi to all,
>>
>>I'm developing a multiuser application with VFP 5, and I'm working on a
>>lock problem.
>>On the workstation A I do this code
>>
>>USE myTable IN 0
>>SELECT myTable
>>
>>RLOCK("1", "myTable") && It return .T.
>>ISRLOCKED(1) && It return .T.
>>
>>while the record 1 is locked I go at the workstation B and I do this code:
>>
>>USE myTable IN 0
>>SELECT myTable
>>
>>ISRLOCKED(1) && It return .F. <<<< ????
>>RLOCK("1", "myTable") && waiting for lock ........ and
>>return .F. (ok record locked by workstation A)
>>
>>Why ISRLOCKED() has returned .F. ? Maybe ISRLOCKED and SYS(2011) return
>>only the lock status modify by my workstation ? Documentation doesn't say
>>it !
>Marco,
>
>ISRLOCKED() tells you if the station the fucntion is called on has a record lock on the record. If you want to know if another station has the record locked you use the RLOCK() function;
>
> IF RLOCK()
> * You got the lock so no one else had it
> ELSE
> * Soemone else has the lock so you can't get it
> ENDIF
Previous
Reply
Map
View

Click here to load this message in the networking platform