Re: Drop Down Box Locking Record

From: tarpon_zeke (anonymous_at_discussions.microsoft.com)
Date: 06/23/04 

Date: Wed, 23 Jun 2004 07:53:50 -0700

I would concur with what you say but I look in the locks
information in SQL Server and the select statement that is
locking the record I am trying to edit is the select
statement from the drop down box and it is on the user I
am logged in as.

Somehow, the drop down box is locking the record. Don't
know how but it is.

PZ

>-----Original Message-----
>Witaj Tarpon_Zeke,
>W Twoim liocie datowanym 22 czerwca 2004 (20:13:05) można
przeczytać:
>
>T> The problem I am having is that the drop down box on
the
>T> prescreen is occasionally locking the record so when
they
>T> go to the full screen they can't update the record.
>
>T> The user is locking himself from editing that record
>T> because of the select statement in the drop down box
which
>T> is looking at the same table and the same record.
>
>T> The strange thing is that if only one person is in the
>T> system, this does not happen. Once multiple users are
in
>T> the system this happens. I figured out a temporary
work
>T> around but it is not a particularly pretty solution.
>
>The dropdown box NORMALLY cannot lock record,
>so you should search another reason, but maybe you have
not
>all/newest updates/patches/MDACs installed?
>
>IMHO the "multi-using" is the real reason.
>Try to check if "locked" record is not currently being
edited/preccessed
>by another user.
>
>Regards
>Jacek Segit
>
>
>.
>

Relevant Pages

  • Re: [PATCH 0/3] 64-bit futexes: Intro
    ... i suspect _any_ abstract locking functionality around a data structure ... tightly coupled to the exact details of which atomics are fast on a ... For example, some loads are almost entirely read-read locks, with only ... There we can just do a write to unlock. ...
    (Linux-Kernel)
  • Re: Transaction Isolation Level
    ... what size servers are you working ... and only have to specify locking hints when we ... need locks. ...
    (microsoft.public.sqlserver.server)
  • Re: Back end database lock-up
    ... Check the open mode and locking strategy of *each* front end. ... database into front end and back end databases and put the front end ... only lock the records that are being updated, but it locks the entire ... The locking file is not created until a user updates the data via ...
    (comp.databases.ms-access)
  • Re: Detecting Table Locks?
    ... And no its not a problem with the sql as to why the operation is taking ... A damn fair use of SQL Server if you ask me (isnt that one of its ... Yes, when your are disconnected there is no locks, but when you call ... The OP is talking about 5 minutes of locking, in my idea that can never be ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: row vs page locking...
    ... so they automatically escalate to page level locks. ... 'Lock Escalation' - see Books Online. ... SQL Server 2005 is going to have a Snapshot ... Good old fashioned locking is less sexy, but I find, more productive! ...
    (microsoft.public.sqlserver.server)