That is a safe way to do it and under most circumstances it is OK to do it
by changing the domain as long as the character fields are longer e.g. 10 ->
20.

Can you do the restore in Verbose mode, see where it breaks and report on
the metadata for that table.

Cheers,

JAC




""Dion Oliphant"" <dion@...> wrote in message
news:000101c275cb$4d118580$3700a8c0@......

> When I have changed any columns, I have droppped those and added them

again.

> Which is better?
>
> Thanks,
> Dion
>
> -----Original Message-----
> From: news@... [mailto:news@...]On Behalf Of Jason
> Chapman (JAC2)
> Sent: Thursday, October 17, 2002 12:03 PM
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] Arithmetic exception, numeric overflow, or
> string truncation
>
>
> Have you changed the width of any columns dynamically by updating the

domain

> directly?
> JAC
>
> ""Dion Oliphant"" <dion@...> wrote in message
> news:000001c275c0$d870b1b0$3700a8c0@......
> > Hi,
> >
> > When I backup my database, I get no errors. When I restore, I get the
> > following error:-
> >
> > 1. Arithmetic exception, numeric overflow, or string truncation.
> >
> > I tried the advice suggested path as laid out in the docs on the

Firebird

> > site ie:-
> >
> > 1. Define the following two variables, it makes life easier, in that

you

> do
> > not have to type in the user name and password every time you issue a
> > command.
> > SET ISC_USER=SYSDBA
> > SET ISC_PASSWORD=masterkey
> > 2. Always make sure you work on a copy of the database, not the

production

> > database. Use the operating system to make a copy of the database. You
> must
> > have exclusive access to the database to do this.
> > copy employee.gdb database.gdb
> > 3. Now check for database corruption. You must have exclusive access to

do

> > this, but since you're working on a copy of the original database, this

is

> > not a problem.
> > gfix -v -full database.gdb
> >
> > etc...
> > but find no errors(at least not on the screen). I pick up the above

error

> > when trying to restore the backed up database.
> >
> > Thanks,
> > Dion.
> >
> >
> >
> >
> > 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/

> >
> >
> >
>
>
>
>
> 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/
>
>
>
>
>
>
>
> 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/
>
>
>