Subject Re: [ib-support] Understanding Transaction-behaviour
Author Claudio Valderrama C.
<guido.klapperich@...> wrote in message
news:3C4D4731.2F487F50@......
>
> In the first case after closing my app OAT has the value 2003. This means
> Transaction 2003 is active. No app and no user is connected to IB. Then I
> start my app again and OAT becomes 2010, this is my problem. How is it
> possible, that my app has commited Transaction 2003 ? I think, when my app
> starts the second time, the first transaction it will get is 2010.

Are you using the raw API to communicate to the engine?
Are you aware that even isql uses three transactions?
How many metadata queries does the db package you use, under the scenes to
get information from the db BEFORE you do anything explicit?

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing