| Subject | RE: [IBDI] Iertbase 6 + paradox + Data pump... |
|---|---|
| Author | David Schnepper |
| Post date | 2000-05-30T13:47:51Z |
It
looks like the problem is pretty simple. Your database is defined as SQL
dialect 3 -- and you are defining a "DATE" column. The message you get is
the one that means "there is a conflict in the understanding of sql between
dialect 1 and dialect 3" in something you've used.
Your
options are
- Recreate the database as a dialect 1 database.
- Recreate the database as a dialect 1 database.
- Use
SQL dialect 3 exclusively (which may not be possible if you're using
BDE)
- Use
TIMESTAMP instead of DATE (which you'ld have to do in sql dialect 3
anyway).
Hope
this helps
Dave
-----Original Message-----
From: Fabrice Vendé - INFOCOB [mailto:fabrice@infocob.com]
Sent: Tuesday, May 30, 2000 2:53 AM
To: ibdi@egroups.com
Subject: [IBDI] Iertbase 6 + paradox + Data pump...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
fabrice@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