Re: Concurrency problems

From: Adam Machanic (amachanic_at_hotmail._removetoemail_.com)
Date: 12/17/04 

Date: Fri, 17 Dec 2004 14:34:24 -0500

"Leila" <Leilas@hotpop.com> wrote in message
news:efspn6G5EHA.2428@TK2MSFTNGP14.phx.gbl...
> Can this be a solution? suppose that:
> client A will attempt to delete the row. It finds out that the row has
been
> marked (client B is editing). It sends a message to B to get a
confirmation.
> If B confirms that it is editing the row, delete will fail unless it will
be
> successful.
> But I'm not sure that if COM or Notification Services can help for this
> communication.
> What is your idea?
> Thanks!
>

    Again, I don't think the database should have any idea what the UI is
doing (so it shouldn't know that ClientB is editing). In my opinion, loose
coupling between databases and applications is very important. Giving the
database knowledge of what the UI is doing very tightly couples them. 

-- 
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--

Relevant Pages

  • Re: Concurrency problems
    ... "Leila" wrote in message ... > client A will attempt to delete the row. ... > marked (client B is editing). ... database knowledge of what the UI is doing very tightly couples them. ...
    (microsoft.public.sqlserver.programming)
  • Re: Document Library
    ... Installing a document management system will allow you to organize things ... My Docs directories for the letters of the alphabet. ... While a user owns the document, editing and commenting are done through ... also in alphabet directories by client name. ...
    (microsoft.public.windows.server.sbs)
  • Re: Concurrency problems
    ... and accuracy to edit these particular records. ... Please just focus on this problem: client A must be prevented from deleting ... Should client B(who is editing the ...
    (microsoft.public.sqlserver.server)
  • Re: Concurrency problems
    ... What if client B crashes while editing and the ... >>'Visible' that will act as a boolean for the UI to display or not display ... >>Adam Machanic ...
    (microsoft.public.sqlserver.programming)
  • Re: Concurrency problems
    ... and accuracy to edit these particular records. ... Please just focus on this problem: client A must be prevented from deleting ... Should client B(who is editing the ...
    (microsoft.public.sqlserver.programming)