Environment versions
Network:
Windows 2003 Server
Hi Farouk,
If this problem is still actual....
A while ago I had a similar problem - sort of "dead lock".
I use SPT , not views. It's a shame for me to say that, but I forgot to put COMMIT transaction in one of my method, which was the reason for the lock. May be you forgot something like this ?
You may also try to run you queries with LOCK HINT
Select * from myTable with (nolock)
Update myTable with (rowlock) set myField=""
Try to do this, see if it helps
Mariam
>Hi all,
>
>I have the above scenario when user A opened form and add a new txn record for the form and saved... User B opened same form and viewing the same record and the app will freezed on user B until user A logout from the app.
>
>From the SQLServer Enterprise Manager, I can see User A has caused a lock on User B on a particular view. This supporting view was requeried in the form refresh method and tableupdate in the saving.
>
>If I move the requery from the refresh method of the form and just b4 and I saved the record (to make sure no same record existense), the lock will not happen... Why?
>
>Regards,
>Farouk Yew
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