Article View: borland.public.cppbuilder.database.ado
Article #5765HowTo: Lock one/set of records
From: yupod
Date: Thu, 08 Feb 2001 16:48
Date: Thu, 08 Feb 2001 16:48
13 lines
1479 bytes
1479 bytes
Hello! I use BCB5 with ADOExpress, connecting to Access97 mdb, I need to lock one record in a table (or result of query) so that nobody else can edit it. Once this record is updated by user I need to unlock it. The only way I can do it now is to set Connection's property Mode to Exclusive. But this makes all records in table locked and is unacceptable to me... I thought if I set ADODataset's properties CursorType=ctKeySet and LockType=ltPessimistic this will do it, but it did not affect anything Please, help me with advice or sample code, Thank you in advance, Yuriy.
Technical Details
Message-ID:
<3a82cd81$2_2@dnews>Path:
arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!news.tele.dk!128.230.129.106!news.maxwell.syr.edu!xfer13.netnews.com!netnews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!dnews!138.89.38.166Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,75dff902085801d3,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2001-02-08 08:50:54 PST Reply-To: "yupod" <yupod@usa.com> From: "yupod" <yupod@usa.com> Newsgroups: borland.public.cppbuilder.database.ado Subject: HowTo: Lock one/set of records Date: Thu, 8 Feb 2001 11:48:47 -0500 Lines: 15 Organization: rms X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 NNTP-Posting-Host: 138.89.38.166 Message-ID: <3a82cd81$2_2@dnews> X-Trace: 8 Feb 2001 08:46:57 -0800, 138.89.38.166 Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!news.tele.dk!128.230.129.106!news.maxwell.syr.edu!xfer13.netnews.com!netnews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!dnews!138.89.38.166