|Subject||Re: [firebird-support] Re: FB 2.1 64 Bits on Win 2003 64, issue with transactions|
> Yes, we have an application that could be left open for hours, and it isWelcome to the brotherhood of tortured database developers :)
> up to the user to close it. The transactions are managed by Firebird
> (in automatic, we dont use Begin Tran and Commit).
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