General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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
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