Article View: borland.public.cppbuilder.database.ado
Article #5831RE: Unlock records in ADO transactions
From: Cristian
Date: Mon, 29 Jan 2001 21:24
Date: Mon, 29 Jan 2001 21:24
36 lines
2312 bytes
2312 bytes
Hi:
Thanks, but the problem is: how can I make changes during a transaction
in a table that is accessing by another transaction? I'm working in a MDI
project, and the Child window have an ADOConnection component. This
connection component open an access table and start a transaction. The first
child window I open present no trouble, then I open another child windown
(the first still open); the BeginTrans method start without erros, but when
I try to post a record a message error pop up: currntly record locked...
What can I do to unlock the record???
When I use Paradox table the solution is TSession component, but in ADO
isn't exist a similar component to TSession. Maybe the problem is that
Access can't accept multiple transaction executing at the same time
accessing the same table, what do you think?
Yuancai (Charlie) Ye <yekerui@yahoo.com> escribi๏ฟฝ en el mensaje de noticias
3a75c3e8$1_2@dnews...
> Hi,
> I think you have to wait until other tranasctions are completed.
>
> Yuancai (Charlie) Ye
> See 26 OLEDB examples at http://www.geocities.com/oledbpro
>
> "Cristian" <cgv@diit.cl> wrote in message news:3a757701_2@dnews...
> > Hi:
> >
> > I'm using BeginTrans method with ADOConnection component but records
are
> > lock to others transactions.
> > How can I unlock records?
> >
> >
> >
>
>
Technical Details
Message-ID:
<3a75d123_2@dnews>Path:
arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-01!supernews.com!newshub2.rdc1.sfba.home.com!news.home.com!news-peer.gip.net!news.gsl.net!gip.net!news.maxwell.syr.edu!colt.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!bornews.borland.com!dnews!200.54.190.254References:
<3a757701_2@dnews> <3a75c3e8$1_2@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,5df411c2233814c8 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2001-01-29 12:29:17 PST From: "Cristian" <cgv@diit.cl> Newsgroups: borland.public.cppbuilder.database.ado References: <3a757701_2@dnews> <3a75c3e8$1_2@dnews> Subject: RE: Unlock records in ADO transactions Date: Mon, 29 Jan 2001 17:24:07 -0400 Lines: 38 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 NNTP-Posting-Host: 200.54.190.254 Message-ID: <3a75d123_2@dnews> X-Trace: 29 Jan 2001 12:22:59 -0800, 200.54.190.254 Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-01!supernews.com!newshub2.rdc1.sfba.home.com!news.home.com!news-peer.gip.net!news.gsl.net!gip.net!news.maxwell.syr.edu!colt.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!bornews.borland.com!dnews!200.54.190.254