Subject Re: [firebird-support] Re: FB 2.1 64 Bits on Win 2003 64, issue with transactions
Author mailstor
> Yes, we have an application that could be left open for hours, and it is
> up to the user to close it. The transactions are managed by Firebird
> (in automatic, we dont use Begin Tran and Commit).

Welcome to the brotherhood of tortured database developers :)
One advice: don't fight it... it's useless.
Accept that your clients will never understand why they should not
keep forms and programs open for hours, days and weeks, especially not
if the "clients" happen to be your colleagues.

If your application development software does not support "offline"
storage of data, try to query the data using "read-only" transactions,
and use a "read-write" transaction only when the user actually is
changing something on the data (Update, Insert, Delete).

If that's too much work, you can most likely implement a "timer" in
your application which re-queries the data in certain intervals when

In the long run, you won't get around explicitely starting and ending