Subject Re: sweep database
Author emb_blaster
--- In, "majstor" <majstoru@...> 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.

IDK if you got that, but, as Ann mentioned, changes can be valid for months and yet NOT be committed. If you said that the SERVER where the database is located is powered off every nitght then we could discard the problem.
What kind of connection and transactions params you use for your Firebird database?