Subject RE: [IBDI] Iertbase 6 + paradox + Data pump...
Author David Schnepper
Post date 2000-05-30T14:29:14Z
Borland elected not update BDE to fully support InterBase v6.0 (eg:SQL dialect 3).  It would work fine if you stay within the feature set of IB v5x, eg: create a database that is sql dialect 1 only.
 
Dave
 
 
 
-----Original Message-----
From: Fabrice Vendé - INFOCOB [mailto:fabrice@infocob.com]
Sent: Tuesday, May 30, 2000 6:54 AM
To: IBDI@egroups.com
Subject: Re: [IBDI] Iertbase 6 + paradox + Data pump...

Thank you for the response,
----- Original Message -----
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@infocob.com
 
-
SARL I N F O C O B
Developpement, formation, matériel, logiciel
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