"majstor" wrote:
<<
I have some strange situation with firebird database and I think that
sweep can be problem. I have n-tier application which is using
oracle, mssql and firebird database for backend storage. For oracle
and mssql all works fine, but some users who use firebird for
database storage have problem that after few days of working some
data (eves server is shutdown) under strange condition return some
old data into some tables.
For example, I have table aricles, and when user made documet who
change price in table articles all works fine for a week in some
cases, but after few days (week in some cases) prices are returned to
old values even there are no new documents.
Is this sweep problem or something else???

>>

I would start to check that transactions are committed.
If you don't commit, your transactions can be rolled back and
resurface old data. E.g. the program updating prices does not
commit, and after some time it is terminated - and voila! - old data is back.


--
Aage J.