Subject | Gbak 1.5.2 fails |
---|---|
Author | Nick Upson |
Post date | 2005-02-04T23:22:20Z |
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
);
--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly
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
);
--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly