Bonjour Bruno,
Je ne trouve pas de fichier " migration.log " dans C/programfiles/ancestrologie mais uniquement ce " modifbase " suivant d'hier :
Statement failed, SQLCODE = @1
unsupported on-disk structure for file @1; found @2.@3, support @4.@5
Use CONNECT or CREATE DATABASE to specify a database
/*Ce script ne doit s'appliquer qu'à des bases de niveau b4.028 et supérieur*/
SET ECHO OFF;
Use CONNECT or CREATE DATABASE to specify a database
/*Modifications de la base permettant d'ajouter la fonction de suivi d'un import et en permettant la suppression ou l'élagage
Les instructions suivantes doivent provoquer des erreurs normales si la fonction est déjà installée*/
CREATE GENERATOR T_IMPORT_GEDCOM_IG_ID_GEN^
Use CONNECT or CREATE DATABASE to specify a database
COMMIT WORK^
Use CONNECT or CREATE DATABASE to specify a database
CREATE TABLE T_IMPORT_GEDCOM (
IG_ID INTEGER NOT NULL,
IG_PATH VARCHAR (255) CHARACTER SET ISO8859_1 NOT NULL COLLATE ISO8859_1,
IG_DATE TIMESTAMP DEFAULT 'NOW' NOT NULL)^
Use CONNECT or CREATE DATABASE to specify a database
COMMIT WORK^
Use CONNECT or CREATE DATABASE to specify a database
ALTER TABLE T_IMPORT_GEDCOM ADD CONSTRAINT PK_T_IMPORT_GEDCOM PRIMARY KEY (IG_ID)^
Use CONNECT or CREATE DATABASE to specify a database
COMMIT WORK^
Use CONNECT or CREATE DATABASE to specify a database
ALTER TABLE INDIVIDU ADD ID_IMPORT_GEDCOM INTEGER^
Use CONNECT or CREATE DATABASE to specify a database
COMMIT WORK^
Use CONNECT or CREATE DATABASE to specify a database
ALTER TABLE MULTIMEDIA ADD ID_IMPORT_GEDCOM INTEGER^
Use CONNECT or CREATE DATABASE to specify a database
COMMIT WORK^
Use CONNECT or CREATE DATABASE to specify a database
ALTER TABLE EVENEMENTS_FAM ADD ID_IMPORT_GEDCOM INTEGER^
Use CONNECT or CREATE DATABASE to specify a database
COMMIT WORK^
Use CONNECT or CREATE DATABASE to specify a database
CREATE PROCEDURE "PROC_PURGE_IMPORT_GEDCOM"
(
"I_CLEF" INTEGER,
"I_MODE" INTEGER
)
RETURNS
(
"INFO" VARCHAR(50) CHARACTER SET ISO8859_1
)
AS
BEGIN EXIT; END ^
Use CONNECT or CREATE DATABASE to specify a database
COMMIT WORK^
Use CONNECT or CREATE DATABASE to specify a database
/*Fin des instructions devant provoquer des erreurs dans certaines circonstances*/
SET ECHO OFF^
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
/*Passage en version 4.029*/
SET ECHO OFF^
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
/*Passage en version 4.030
L'instruction suivante doit provoquer une erreur normale si le trigger est déjà créé*/
CREATE TRIGGER "TAD_EVENEMENTS_IND" FOR "EVENEMENTS_IND"
ACTIVE AFTER DELETE POSITION 0
as
/*Création par André le 25/03/2006
maj INDIVIDU after delete*/
BEGIN
IF (OLD.EV_IND_TYPE='BIRT') THEN
UPDATE INDIVIDU
SET DATE_NAISSANCE=NULL,
ANNEE_NAISSANCE=NULL,
AGE_AU_DECES=NULL
WHERE CLE_FICHE=OLD.EV_IND_KLE_FICHE;
IF (OLD.EV_IND_TYPE='DEAT') THEN
UPDATE INDIVIDU
SET DATE_DECES=NULL,
ANNEE_DECES=NULL,
AGE_AU_DECES=NULL
WHERE CLE_FICHE=OLD.EV_IND_KLE_FICHE;
END
^
Use CONNECT or CREATE DATABASE to specify a database
COMMIT WORK ^
Use CONNECT or CREATE DATABASE to specify a database
/*Fin erreurs normales*/
SET ECHO OFF^
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
Use CONNECT or CREATE DATABASE to specify a database
/*Passage en version 4.031
L'utilisation de la base modifiée avec une version du logiciel inférieure à V500 peut entraîner des disfonctonnements.*/
SET ECHO OFF;
Use CONNECT or CREATE DATABASE to specify a database
A te lire.
Charles