Hi Carsten,

[snip]

> > this is something I can't reproduce with FB 1.0 Build 796.
> >
> > To be sure, I used isql.exe and not a third-party tool and
> > after altering a table with:
> >
> > SQL> alter table mytable2 add myint2 integer not null;
> > SQL> commit;
> >
> > A select
> >
> > SQL> select myint2 from mytable2;
> >
> > shows the value 0 for myint2 for old records, so the database
> > *should* be in a restoreable state.
> >
>
> This is what i see, too.
> But the database is not restorable until i do a explicit
> "update t_einfachangebot set f_id_ma_beleg = 0;"

Any chance that there is a trigger or updateable foreign key
constraint, which gets fired when the table is updated again,
so that T_ERGEBNIS is in a restoreable state then?

What is the full DDL of T_ERGEBNIS, T_EINFACHANGEBOT including
triggers?


Regards,
Thomas.