-----Message d'origine-----
De : Fabrice Vendé - INFOCOB [mailto:fabrice@...]
Envoyé : mardi 30 mai 2000 14:39
À : IBDI@egroups.com
Objet : Re: [IBDI] Iertbase 6 + paradox + Data pump...

Hi,


> 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

This doesn't work better:

CREATE TABLE Historique(
H_Code CHAR(15),
H_Compteur SMALLINT,
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 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)
);

This give error:
"Metadata update statement is not allowed by the current database SQL
dialect 3"

Fabrice Vende
fabrice@...

-
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