> To be precise. I made dataset components where before open they create
> transaction component on runtime, they open the transaction and so on. On
> close or on destroy they commit or roleback the transaction anyway. There

is

> no transaction component at design time at all in whole application. I

made

> this for more automated procedure in order to avoid unhandled

transactions.

>
> I will check my code but let me ask you this: suppose that a terminal went
> to a form that opens a transaction and waits the user to select something
> from the dataset. And this terminal is not used for some days! Does this
> opened transaction can produce this gap?

I wouldn't know why not.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com