----- Original Message -----

From: David Schnepper

To: IBDI@egroups.com

Sent: Tuesday, May 30, 2000 3:47 PM

Subject: RE: [IBDI] Iertbase 6 + paradox + Data pump...

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.

- 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

 

 

I use BDE,

 

This work fine :

CREATE TABLE Historique(
 H_Code VARCHAR(15) NOT NULL,
 H_Compteur INTEGER,
 H_Code_Action_Origine VARCHAR(15),
 H_CodeSociete VARCHAR(5),
 H_CodeContact VARCHAR(20),
 H_CodeInterlocuteur_sour VARCHAR(20),
 H_CodeInterlocuteur_dest VARCHAR(20),
 H_Date_Saisie TIMESTAMP ,
 H_Date_Prevu TIMESTAMP ,
 H_Heure_Prevu TIMESTAMP ,
 H_Date_Realise TIMESTAMP ,
 H_Duree TIMESTAMP ,
 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)
)

 

Why the datapump program (with delphi/c++builder) doesn't work with interbase 6.2 ?

It is a very usefull tools to convert paradox alias to inerbase one.

It's work fine with old interbase 5.6 version and with odbc driver like MySQL.

 

 

Fabrice Vende
fabrice@...

 

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