Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread How to solve this error ?
Sat, Aug 12 2006 3:06 AMPermanent Link

"Erik"
Hi

One of our customers is getting the following error message:

Database X already has an active transaction.

What can I do to solve this error (and eventually: how can I prevent this in
the future?)

regards

Erik

Sat, Aug 12 2006 7:19 AMPermanent Link

"Jose Eduardo Helminsky"
Erik

You don´t post the code you are receiving the error but this happen when you
start a new transaction on a database that already are inside a transaction.
Depends on your code but you can use:

if not Database.InTransaction then begin
   Database.StartTransaction;
end;

Eduardo

Sat, Aug 12 2006 8:13 AMPermanent Link

"Erik"
Eduardo,

I tried this part of the application on my test-pc and all went well.
The customer can even shutdown the app. and the computer.
After that, starting again this function the error comes on screen....

I wonder if it might help to shutdown the app. and remove all dbisam.lck
files from this computer ??

(dbisam 4.21)

Erik



"Jose Eduardo Helminsky" <contato@hpro.com.br> schreef in bericht
news:F1CB3533-4607-4753-B173-1365BB41591F@news.elevatesoft.com...
> Erik
>
> You don´t post the code you are receiving the error but this happen when
> you start a new transaction on a database that already are inside a
> transaction. Depends on your code but you can use:
>
> if not Database.InTransaction then begin
>    Database.StartTransaction;
> end;
>
> Eduardo
>

Mon, Aug 14 2006 9:03 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Erik,

<< I wonder if it might help to shutdown the app. and remove all dbisam.lck
files from this computer ?? >>

That won't help - this is a coding issue, pure and simple.   Is your
application multi-threaded at all ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Wed, Aug 16 2006 11:21 AMPermanent Link

"Erik"
Tim,

Of course you where right. It was a very nasty and mean bug which I allready
solved and my customer is happy again.
Thanks all for your help..


Regards

Erik


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> schreef in bericht
news:8ABC33E8-C6AC-4941-92BA-4E672996A7C8@news.elevatesoft.com...
> Erik,
>
> << I wonder if it might help to shutdown the app. and remove all
> dbisam.lck files from this computer ?? >>
>
> That won't help - this is a coding issue, pure and simple.   Is your
> application multi-threaded at all ?
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>

Image