Hi,

> Fabrice,
>
> At a guess, I'd say you have forgotten to define some domains. You are
> specifying data types that don't exist in InterBase. AUTOINC, MEMO and

BIT

> are not IB data types so, if it worked before, you must have had domains
> for them.
>
> Remember, too, that IB doesn't have an auto-incrementing field
> type. Instead, define the field as integer (or a domain that is an
> integer) and have a BEFORE INSERT trigger to fire it.
>
> hth

This doesn't work better:

CREATE TABLE Historique(
H_Code CHAR(15),
H_Compteur SMALLINT,
H_Code_Action_Origine CHAR(15),
H_CodeSociete CHAR(5),
H_CodeContact CHAR(20),
H_CodeInterlocuteur_sour CHAR(20),
H_CodeInterlocuteur_dest CHAR(20),
H_Date_Saisie DATE,
H_Date_Prevu DATE,
H_Heure_Prevu DATE,
H_Date_Realise DATE,
H_Duree DATE,
H_Affaire VARCHAR(15),
H_Detail BLOB,
H_Nom_Action VARCHAR(40),
H_Delai FLOAT,
H_InfoLibre1 VARCHAR(40),
H_InfoLibre2 VARCHAR(40),
H_infoLibre3 VARCHAR(40),
H_BoolLibre1 VARCHAR(1),
H_BoolLibre2 VARCHAR(1),
PRIMARY KEY (H_Code)
);

This give error:
"Metadata update statement is not allowed by the current database SQL
dialect 3"

Fabrice Vende
fabrice@...

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