> Ahh... do you have any long strings? Longer than say 32K? The expansion
> buffer for the transportable backup was created with a signed long,
> where an unsigned long would have been better. I think that's fixed
> in later V6 versions.

You want to say blob fields ?

If yes I use tables like this :

CREATE TABLE CONTACTFICHE
(
C_CODE VARCHAR(15) NOT NULL,
C_COMPTEUR INTEGER,
C_CODESOCIETE VARCHAR(5),
C_QUALIF VARCHAR(10),
C_NOM VARCHAR(50),
C_PRENOM VARCHAR(50),
C_ADRESSE VARCHAR(255),
C_CP VARCHAR(10),
C_VILLE VARCHAR(30),
C_PAYS VARCHAR(30),
C_TEL1 VARCHAR(20),
C_TEL2 VARCHAR(20),
C_TEL3 VARCHAR(20),
C_TEL4 VARCHAR(20),
C_EMAIL VARCHAR(50),
C_DATE1CONTACT TIMESTAMP,
C_MODE1CONTACT VARCHAR(20),
C_MODECONNAISSANCE VARCHAR(20),
C_FAMILLECONTACT VARCHAR(30),
C_COMMENTAIRE VARCHAR(255),
C_COMMENTAIREINTERNE BLOB SUB_TYPE TEXT SEGMENT SIZE 80,
C_INTERET VARCHAR(2),
C_CODEUTILISATEUR VARCHAR(20),
C_NBSAL DOUBLE PRECISION,
C_SECTEUR VARCHAR(40),
C_MAILING VARCHAR(1),
C_PHONNING VARCHAR(1),
C_EXPORT VARCHAR(1),
C_INFOLIBRE1 VARCHAR(40),
C_INFOLIBRE2 VARCHAR(40),
C_INFOLIBRE3 VARCHAR(40),
C_INFOLIBRE4 VARCHAR(40),
C_INFOLIBRE5 VARCHAR(40),
C_INFOLIBRE6 VARCHAR(40),
C_INFOLIBRE7 VARCHAR(40),
C_INFOLIBRE8 VARCHAR(40),
C_INFOLIBRE9 VARCHAR(40),
C_INFOLIBRE10 VARCHAR(15),
C_INFOLIBRE11 VARCHAR(15),
C_INFOLIBRE12 VARCHAR(15),
C_INFOLIBRE13 VARCHAR(15),
C_DATELIBRE1 TIMESTAMP,
C_DATELIBRE2 TIMESTAMP,
C_NBRLIBRE1 DOUBLE PRECISION,
C_NBRLIBRE2 DOUBLE PRECISION,
C_BOOLLIBRE1 VARCHAR(1),
C_BOOLLIBRE2 VARCHAR(1),
C_BOOLLIBRE3 VARCHAR(1),
C_TAILLE1_MIN DOUBLE PRECISION,
C_TAILLE1_MAX DOUBLE PRECISION,
C_TAILLE2_MIN DOUBLE PRECISION,
C_TAILLE2_MAX DOUBLE PRECISION,
C_TAILLE3_MIN DOUBLE PRECISION,
C_TAILLE3_MAX DOUBLE PRECISION,
C_BUDGET DOUBLE PRECISION,
C_MONNAIE VARCHAR(10),
C_WEB VARCHAR(255),
C_APE VARCHAR(5),
C_ALERT DOUBLE PRECISION,
C_STATUS VARCHAR(50),
C_PFAMILLE VARCHAR(20),
C_PCONSTRUCTEUR VARCHAR(20),
C_PNSERIE VARCHAR(15),
C_PNOMBAPTEME VARCHAR(30),
C_PDATECONSTRUCTION VARCHAR(4),
C_P1UTILISATION VARCHAR(4),
C_PCONTRAT VARCHAR(30),
C_PLOCALISATION1 VARCHAR(20),
C_PLOCALISATION2 VARCHAR(20),
C_PLOCALISATIONVILLE VARCHAR(30),
C_PLOCALISATIONSECTEUR VARCHAR(30),
C_PETATPRODUIT VARCHAR(20),
C_LANGUE VARCHAR(30),
C_PROFESSION VARCHAR(30),
C_DATEMODIF TIMESTAMP,
C_DATECREATION TIMESTAMP,
C_REFFIXE VARCHAR(9),
C_REFVARIABLE VARCHAR(20),
C_SECTEURACTIVITE VARCHAR(50),
C_CONCURRENT1 VARCHAR(30),
C_CONCURRENT2 VARCHAR(30),
C_CONCURRENT3 VARCHAR(30),
C_CONCURRENT4 VARCHAR(30),
C_CA_N FLOAT,
C_CA_N1 FLOAT,
C_GROUPEMENT VARCHAR(30),
C_DIVERSTXT1 VARCHAR(30),
C_DIVERSTXT2 VARCHAR(30),
C_DIVERSTXT3 VARCHAR(30),
C_DIVERSTXT4 VARCHAR(30),
C_DIVERSTXT5 VARCHAR(30),
C_DIVERSTXT6 VARCHAR(30),
C_DIVERSTXT7 VARCHAR(30),
C_DIVERSTXT8 VARCHAR(30),
C_DIVERSTXT9 VARCHAR(30),
C_DIVERSTXT10 VARCHAR(30),
C_DIVERSTXT11 VARCHAR(30),
C_DIVERSTXT12 VARCHAR(30),
C_DIVERSNUM1 FLOAT,
C_DIVERSNUM2 FLOAT,
C_DIVERSNUM3 FLOAT,
C_DIVERSNUM4 FLOAT,
C_DIVERSNUM5 FLOAT,
C_DIVERSBOOL1 VARCHAR(1),
C_DIVERSBOOL2 VARCHAR(1),
C_DIVERSBOOL3 VARCHAR(1),
C_DIVERSBOOL4 VARCHAR(1),
C_DIVERSBOOL5 VARCHAR(1),
C_DIVERSDATE1 TIMESTAMP,
C_DIVERSDATE2 TIMESTAMP,
C_DIVERSDATE3 TIMESTAMP,
C_DIVERSDATE4 TIMESTAMP,
C_DIVERSDATE5 TIMESTAMP,
C_CODEIMPORT VARCHAR(20),
C_PCP VARCHAR(10),
C_PPAYS VARCHAR(30),
C_PADRESSE VARCHAR(255),
PRIMARY KEY (C_CODE)
);


Fabrice Vende
fabrice@...

-
SARL I N F O C O B
Developpement, formation, matériel, logiciel
http://www.infocob.com