Article View: borland.public.cppbuilder.database.ado
Article #5786Re: Update conflict resolution strategy
From: Eric
Date: Mon, 12 Feb 2001 23:07
Date: Mon, 12 Feb 2001 23:07
20 lines
1638 bytes
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-mailReferences:
<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