Subject Re: [firebird-support] Re: sweep database
Author Ann W. Harrison
On 9/20/2010 1:12 PM, majstor wrote:
> Hi Ann& emb_blaster
> Changes are committed because those changes are valid for few days, and after that the changes are returned to old values. Between that some machines are power off every night at the end of work time. Software use same procedure, same logic and same client application for all of 3 database systems and just firebird work like this :-(
> System restore is turned off on all of my installed systems!
> Where can be the problem if the sweep isn't?

As I said earlier, it's something else. The fact that a record can
be seen by the transaction that committed it doesn't mean that the
record is committed. Is your application multi-user? Can all users
see the data that disappears? Are you perhaps defaulting to auto-commit
on other systems and not on Firebird?

Good luck,