| Subject | Iertbase 6 + paradox + Data pump... |
|---|---|
| Author | Fabrice Vendé - INFOCOB |
| Post date | 2000-05-30T09:52:56Z |
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);
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"
Metadata update statement is not allowed by the current database SQL dialect 3"
But it work fine with Interbase 5.6...
Fabrice Vende
fabrice@...
fabrice@...