Results 1 to 6 of 6

Thread: Concurrent Data Usage

  1. Apr 11th, 2006, 11:17 AM #1
    yrwyddfa
    yrwyddfa is offline

    Thread Starter
    Frenzied Member yrwyddfa's Avatar
    Join Date
    Aug 2001
    Location
    England
    Posts
    1,253

    Concurrent Data Usage

    Just a quick straw poll . . . .

    How do you guys achieve resilience in the face that multiple users can change records at the same time?
    "As far as the laws of mathematics refer to reality, they are not certain; and as far as they are certain, they do not refer to reality." - Albert Einstein

    It's turtles! And it's all the way down
    Reply With Quote Reply With Quote
  2. Apr 11th, 2006, 11:52 AM #2
    salvelinus
    salvelinus is offline
    Frenzied Member
    Join Date
    Feb 2003
    Location
    Argentina
    Posts
    1,950

    Re: Concurrent Data Usage

    By rolling back every transaction.
    Tengo mas preguntas que contestas
    Reply With Quote Reply With Quote
  3. Apr 11th, 2006, 11:30 PM #3
    dee-u
    dee-u is offline
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: Concurrent Data Usage

    Quote Originally Posted by yrwyddfa
    Just a quick straw poll . . . .

    How do you guys achieve resilience in the face that multiple users can change records at the same time?
    Is that supposed to be "change the same record at the same time"?
    Regards,

    ™

    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system
    Reply With Quote Reply With Quote
  4. Apr 12th, 2006, 02:47 AM #4
    yrwyddfa
    yrwyddfa is offline

    Thread Starter
    Frenzied Member yrwyddfa's Avatar
    Join Date
    Aug 2001
    Location
    England
    Posts
    1,253

    Re: Concurrent Data Usage

    Sort of.

    Two (or more) users both working on the same set of data. How do you manage the updates?
    "As far as the laws of mathematics refer to reality, they are not certain; and as far as they are certain, they do not refer to reality." - Albert Einstein

    It's turtles! And it's all the way down
    Reply With Quote Reply With Quote
  6. Apr 12th, 2006, 04:39 AM #5
    dee-u
    dee-u is offline
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: Concurrent Data Usage

    This may impart some important info...
    Regards,

    ™

    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system
    Reply With Quote Reply With Quote
  7. Apr 13th, 2006, 04:20 AM #6
    mikee_phil
    mikee_phil is offline
    Hyperactive Member
    Join Date
    Feb 2006
    Location
    Philippines
    Posts
    468

    Re: Concurrent Data Usage

    Sort of.

    Two (or more) users both working on the same set of data. How do you manage the updates?
    i used transaction method on update,delete and insert method
    when the record was locked by the first user and some user also modifying the same record you can rollback transaction to those other user as the error fires "row cannot be located ....." something like that on bound controls or " currently lock" on adodb.connection, and then issue the requery to read the updated values..
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width