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

Helen

At 11:52 AM 30-05-00 +0200, you wrote:

>Hi list,
>
>I try to convert some paradox tables to interbase 6.0 with datapump.
>I try to convert a paradox table like this:
>
>CREATE TABLE Historique(
> H_Code CHAR(15),
> H_Compteur AUTO INC,
> 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 CHAR(15),
> H_Detail MEMO,
> H_Nom_Action VARCHAR(40),
> H_Delai FLOAT,
> H_InfoLibre1 VARCHAR(40),
> H_InfoLibre2 VARCHAR(40),
> H_infoLibre3 VARCHAR(40),
> H_BoolLibre1 BIT,
> H_BoolLibre2 BIT,
> PRIMARY KEY (H_Code)
>);
>CREATE INDEX I_H_Duree ON Historique(H_Duree);
>CREATE INDEX I_H_Prevu ON Historique(H_Date_Prevu);
>CREATE INDEX I_H_Nom_Action ON Historique(H_Nom_Action);
>CREATE INDEX I_H_Vendeur ON Historique(H_CodeInterlocuteur_dest);
>CREATE INDEX I_H_CodeContact ON Historique(H_CodeContact);
>CREATE INDEX I_H_Date_Saisie ON Historique(H_Date_Saisie);
>CREATE INDEX I_H_Date_Realise ON Historique(H_Date_Realise);
>But I have this error:
>"Erreur SQL générale (General SQL error).
>Metadata update statement is not allowed by the current database SQL
>dialect 3"
>
>But it work fine with Interbase 5.6...
>
>Fabrice Vende
><mailto:fabrice@...>fabrice@...
>
>-
>SARL I N F O C O B
>Developpement, formation, matériel, logiciel
><http://www.infocob.com>http://www.infocob.com
>
>
>
>
>----------
>Community email addresses:
> Post message: IBDI@onelist.com
> Subscribe: IBDI-subscribe@onelist.com
> Unsubscribe: IBDI-unsubscribe@onelist.com
> List owner: IBDI-owner@onelist.com
>
>Shortcut URL to this page:
>
><http://www.onelist.com/community/IBDI>http://www.onelist.com/community/IBDI

http://www.interbase2000.org
___________________________________________________
"Ask not what your free, open-source database can do for you,
but what you can do for your free, open-source database."
(J.F.K.)