guido.klapperich@... wrote:

>
> Now to my question. How is it possible, that the OAT has moved. At the
> second run, the first transaction, that my app has opened is 2875. But
> who (and how) has commited the OAT=2867 ?
> Can anybody explain this to me ?
>

Your missing one simple thing - to get the transaction information requires
starting a transaction. Client tools often have several transactions open.
ISQL, for example typically has three on the go and you can usually only
commit one of them interactively.

When you disconnect the server can then move the OAT along, but of course to
see this you have to reconnect and start another transaction. You have already
found out that this is a bit like chasing your own tail.


Paul
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further