At 11:22 PM 4/02/2005 +0000, you wrote:

>I backed up with 1.02 restored with 1.5.2 fine
>then I backed up with 1.5.2 and restored with 1.5.2
>and I get:
>
>gbak: restoring data for table ESTIMATEMAT
>gbak: ERROR: string truncated
>gbak: Exiting before completion due to errors
>
>any ideas why/how this should happen and how I can fix it
>
>
>CREATE TABLE ESTIMATEMAT (
> ESTIMATEMAT_U INTEGER NOT NULL,
> ESTIMATEHDR_U INTEGER NOT NULL,
> SPECHDR_U INTEGER DEFAULT 0 NOT NULL,
> TYPENUMBER INTEGER DEFAULT 0 NOT NULL,
> MATBRAND_U INTEGER NOT NULL,
> BLANKAREA INTEGER DEFAULT 0 NOT NULL,
> COSTPER1000 FLOAT DEFAULT 0.0 NOT NULL,
> COVERAGE INTEGER DEFAULT 0 NOT NULL,
> MATTYPE VARCHAR(20) NOT NULL,
> COST FLOAT DEFAULT 0.0 NOT NULL,
> QTYUSED FLOAT DEFAULT 0.0 NOT NULL,
> ASPECT CHAR(8) DEFAULT '-None-' NOT NULL
>);

Did you change the table's definition between the original restore and the
second one? It can only be MATTYPE or ASPECT.

Maybe, since ASPECT is a char(8), it might be that an insert in between
times, that applied the default, has caused it (guessing wildly...the
default value has only 6 characters..., so it's recognised on restore as
"truncated"...?)

./hb