Hello All

I'd like to ask how do you deal with lost firebird connections in your
applications.
Nowadays lot's of people work remotely using VPN connections over
internet. We all know that even short interruption requires re-login.
I'd like to do it in the application without user attendance. Do you
mind sharing your solutions?
What I am most interested in is the solution for the scenario when the
records are inserted and/or edited within single transaction and when
user want to commit his work it appear that connection was los, he has
to re-login and repeat the work. I was thinking about involving 'cached
updates' feature, but what about the transaction?

So I will appreciate any suggestions.
@Jason? Especially from you, the master of IBO

TIA
Marcin