Thomas,
after my alter table i can do a select where f_id_ma_beleg != 0 and i get no result,
so it seems that everything ist alright.
The error message during restore is:
Arithmetic overflow or division by zero has occurred.
arithmetic exception, numeric overflow, or string truncation.
(the last message before this is:
gbak: restoring data for table T_ERGEBNIS
I don't understand this, because t_eregbnis has no connection to the problem)

If i do a
update t_einfachangebot set f_id_ma_beleg = 0;
(although the select before this update has shown that all values are 0)
and than make the backup it is restorable and everything is OK.


gruß
Carsten

----- Original Message -----
From: "Thomas Steinmaurer" <ts@...>
To: <ib-support@yahoogroups.com>
Sent: Thursday, March 06, 2003 12:49 PM
Subject: RE: [ib-support] Re: Database corruption after alter table


> Carsten,
>
> > Alexander,
> > i think it is all right, what you have written, but it's not relevant for my case.
> > (there was no data insertet in the database after my updates)
> > I forget to define a default value.
> > Why is there no error raised from the database, if this leads to unrestorable backups ?
>
> When I insert a new field with NOT NULL but without a DEFAULT
> value, then dependent on the used data type a value is inserted
> for existing records automatically. e.g. 0 for Integer, empty
> string for VARCHAR, ... so this shouldn't be the problem.
>
> I'm using Firebird 1.0 Build 796.
>
> What exact error message do you get during the restore?
>
> Regards,
> Thomas.
>
>
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>