Are you using NBAK? Maybe the changes to the database are written to a
different file?

Salim


--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@...> wrote:

>
> kjuib999 wrote:
> >
> >
> > I checked the generators on the 2 databases I have and it seems that
> > the generators have been set back (The generators correspond the ID

of

> > the last record)
> > If that is the case... how could a firebird act just fine until the
> > connection is lost... wouldn't there be write issues?
>
> I haven't kept track of what operating system you're using, but on
> some OS's, it's possible to replace a file while it's open. Access
> continues to the old file until it is closed. The next time the
> file is opened, you get the replacement version.
>
> If your generators are being set back, then it's not a transaction
> problem. It's almost certainly the file system doing you a favor.
>
> Regards,
>
>
> Ann
>