Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Attempting to lock problem
Message
From
17/11/1999 16:18:13
 
 
To
17/11/1999 15:56:54
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00292064
Message ID:
00292118
Views:
25
>>Hi all,
>>
>>My users are getting an "Attempting to lock ... Esc to continue" error
>>message. This is happening after changing a feild in a grid. The
>>grid's record source is a view and it is buffered. Multilocks is on,
>>and set reprocess it set to automatic. These setting are in the init
>>of the form.
>>
>>Everywhere I do a rlock() I also do an unlock all. If the rlock() is
>>in an if statement the unlock all is after the endif. I have looked
>>and looked for the cause of this problem but have not found anything.
>>
>
>
>What are you using RLOCK() with views for in the first place? You shouldn't ever have to do this.

That is part of the problem, I am looking at the code and there are only 2
rlocks in the screen, One in the add to increment the PK (in a system table)
the other would not come into play in the above situation.

Does tableupdate perform a lock?

Also I think I understand why you would say never use rlock with views but I
am new to views so to make sure I understand. Is it because views are just
a tempary copy of the data stored on the tmpfiles directory and therefore
the user has exclusive use and would not need to lock?

Thanks for your help

Jeff
Previous
Reply
Map
View

Click here to load this message in the networking platform