RE: Retreive, Update, Delete problem....

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

thank you Jason..

"Daniel" wrote:

> Hi All,
> I have question regarding to the read, and update the row in the table.
>
> for example:
> user A, read the row of data from the table.
> user B, read the row of data from the table as well.
> user A, update the row of data. (lock)
> user B, update the row of data. (fail due to user A lock)
> user A, release the lock. (unlock)
> At the user B side, the data auto refresh in the data grid table.
> This time, user B update the row of data (lock).
> Lastly, user B unlock the row of data. (unlock).
>
> My question is:
> how to implement this in the web form.
> Any additional setting is needed in sql server 2000?
> What is the additional code is needed to the coding page?
> What is the additional T-SQL language is needed in our query? "? Insert..?
> Select.. ? Update..? Delete..".
>
> Any ideas? Any guidelines?
> Your help will be appreciated.
>
> Thank you in advance.
>
> Best regards,
> Daniel.
.

Relevant Pages

  • Re: speeding up inserts
    ... locking the table before doing them and unlocking the table afterwards. ... In case "mysql" in the second paragraph is a type for MS SQL Server, ... answer is that you cannot really lock a table as such in MS SQL Server, ... and definitely not unlock it. ...
    (comp.databases.ms-sqlserver)
  • Retreive, Update, Delete problem....
    ... (fail due to user A lock) ... user B unlock the row of data. ... Any additional setting is needed in sql server 2000? ... What is the additional code is needed to the coding page? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Refresh Problem
    ... If I wait 3 seconds between mouse clicks on the lock / unlock button, ... workstation is looking at a current copy of the data. ... MESSAGEBOX statement after all of the database lookups have been done ...
    (microsoft.public.fox.programmer.exchange)
  • Re: A scoped lock/unlock implementation in C++.
    ... mutex_locker wrapping the same mutex, more than one thread won't share ... But beyond that it will still work with thread local mutex_locker instances, since no two threads can have a nonzero lock count anyway. ... When entering a locked region, if the last entry is negative, you know ... In case of unlocks even the unlock count is insignificant. ...
    (comp.programming.threads)
  • Re: [PATCH] Remove softlockup from invalidate_mapping_pages.
    ... These block devices are very likely to have just one ... Being locked for read is very unlikely because mdadm would have already ... memory reclaim could lock the page, ... core is free to unlock the page when the IO completes, ...
    (Linux-Kernel)