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/