Unlock records in ADO transactions

Thread View: borland.public.cppbuilder.database.ado

5 messages

[T] Back to Threads [V] Tree View [G] Group Articles

5 total messages Started by Cristian Mon, 29 Jan 2001 14:59

#5829

Author: Cristian
Date: Mon, 29 Jan 2001 14:59

5 lines
947 bytes

Hi:

I'm using BeginTrans method  with ADOConnection component but records are
lock to others transactions.
How can I unlock records?

Re: Unlock records in ADO transactions

#5830

Author: Yuancai (Charlie) Ye
Date: Mon, 29 Jan 2001 19:32

15 lines
1320 bytes

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?
>
>
>

Re: Unlock records in ADO transactions

#5832

Author: Yuancai (Charlie) Ye
Date: Mon, 29 Jan 2001 21:02

53 lines
2812 bytes

Hi,
    Access doesn't support nested transactions. It supports one transaction
per session at one time. One record can be locked by two transactions at the
same time. I guess you are right. So you have to start a transaction after
another transaction is done.

Yuancai (Charlie) Ye
See 26 OLEDB examples at http://www.geocities.com/oledbpro


"Cristian" <cgv@diit.cl> wrote in message news:3a75d123_2@dnews...
> 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?
> > >
> > >
> > >
> >
> >
>
>

Re: Unlock records in ADO transactions

#5833

Author: Yuancai (Charlie) Ye
Date: Mon, 29 Jan 2001 21:04

54 lines
2845 bytes

Hi,
    Forget the last message.
    Access doesn't support nested transactions. It supports one transaction
per session at one time. One record can NOT be locked by two transactions at
the
same time. I guess you are right. So you have to start a transaction after
another transaction is done.

Yuancai (Charlie) Ye
See 26 OLEDB examples at http://www.geocities.com/oledbpro

"Cristian" <cgv@diit.cl> wrote in message news:3a75d123_2@dnews...
> 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?
> > >
> > >
> > >
> >
> >
>
>

RE: Unlock records in ADO transactions

#5831

Author: Cristian
Date: Mon, 29 Jan 2001 21:24

36 lines
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?
> >
> >
> >
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads