🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #5786

Re: Update conflict resolution strategy

#5786
From: Eric
Date: Mon, 12 Feb 2001 23:07
20 lines
1638 bytes
A  very simple strategy we use is to have a column in the table that
stores last modification date/time and by whom.  When a client
attempts to save the record  this column is compared against a value
stored when the user opened the record.  It is simple but suit our
needs.

On Mon, 12 Feb 2001 13:49:02 -0500, "Tony" <hse@hill-soft.com> wrote:

>Does anyone have or know of a cppbuilder or delphi example of resolving
>update conflicts using client side static cursors, optimistic locking and
>Access 2000? My app has many bound controls so the code to resolve conflicts
>need to be in events such as AppsRecordChangeComplete. I'm looking for
>something very simple (as a starting point) that would tell the current user
>that another user had modified the underlying data and ask the user if they
>want to abandon their changes or overwrite the other users changes.
>
>


Eric
Technical Details
Message-ID: <3a886bb7.4266382393@forums.inprise.com>
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!newsswitch.lcs.mit.edu!howland.erols.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!not-for-mail
References: <3a882f8d_2@dnews>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,646611dd911450b4
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-02-12 15:14:08 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!newsswitch.lcs.mit.edu!howland.erols.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!not-for-mail
From: erico@mediserve.com (Eric)
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: Update conflict resolution strategy
Date: Mon, 12 Feb 2001 23:07:41 GMT
Organization: Another Netscape Collabra Server User
Lines: 21
Message-ID: <3a886bb7.4266382393@forums.inprise.com>
References: <3a882f8d_2@dnews>
NNTP-Posting-Host: 63.108.231.210
X-Newsreader: Forte Free Agent 1.21/32.243