Article View: borland.public.cppbuilder.database.ado
Article #5790Re: Update conflict resolution strategy
From: Tony
Date: Tue, 13 Feb 2001 04:17
Date: Tue, 13 Feb 2001 04:17
29 lines
2052 bytes
2052 bytes
Thanks for your response. I guest what I'm looking for here are specific code examples of simple common stategies. Eric <erico@mediserve.com> wrote in message news:3a886bb7.4266382393@forums.inprise.com... > 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:
<3a88b4bb_1@dnews>Path:
arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!news.tele.dk!213.56.195.71!fr.usenet-edu.net!usenet-edu.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!dnews!166.90.236.246References:
<3a882f8d_2@dnews> <3a886bb7.4266382393@forums.inprise.com>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 20:22:24 PST From: "Tony" <hse@hill-soft.com> Newsgroups: borland.public.cppbuilder.database.ado References: <3a882f8d_2@dnews> <3a886bb7.4266382393@forums.inprise.com> Subject: Re: Update conflict resolution strategy Date: Mon, 12 Feb 2001 23:17:16 -0500 Lines: 31 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 NNTP-Posting-Host: 166.90.236.246 Message-ID: <3a88b4bb_1@dnews> X-Trace: 12 Feb 2001 20:14:51 -0800, 166.90.236.246 Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!news.tele.dk!213.56.195.71!fr.usenet-edu.net!usenet-edu.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!dnews!166.90.236.246