Hmmm. This error while restoring doesn't happen when restoring the table
PESSOA, but while restoring other table.
Better i take a closer look.

----- Original Message -----
From: "Valdir Stiebe Junior" <valdir@...>
To: <ib-support@yahoogroups.com>
Sent: Wednesday, April 16, 2003 1:03 PM
Subject: [ib-support] Help recovering from an error.


> Hi, I'm using Firebird 1.0.2 and
> here are the steps i've made:
>
> 1. FORGOT to execute: update PESSOA set CONTATO = 0 where CONTATO is null;
>
> 2. update RDB$RELATION_FIELDS set RDB$NULL_FLAG = 1 where (RDB$FIELD_NAME
=
> 'CONTATO') and (RDB$RELATION_NAME = 'PESSOA');
>
> 3. backup
>
> 4. impossible to restore due arithmetic truncation or string overflow
while
> recovering data from table PESSOA because some records have the field
> CONTATO null
>
> I already tried to update the RDB$NULL_FLAG to null, then backup and
> restore. But doesn't work.
>
> Any way i can back the GDB to a normal state?
>
> ps.: Lession learned: 'Pay attention when messing with system tables and
> don't mess with system tables unless extremely necessary.'
>
>
>
> 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/
>