FORUMS PROFESSIONNELS
WINDEV
,
WEBDEV
et
WINDEV Mobile
Accueil
|
Messages récents
|
Connexion
|
Déconnexion
|
Français
Accueil
→
WINDEV 2024
→
abnormal The constraint for referential integrity error
abnormal The constraint for referential integrity error
Débuté par BG, 17 sep. 2014 13:23 - 4 réponses
Connectez-vous…
BG
#1
Posté le 17 septembre 2014 - 13:23
Hello all,
While updating an existing system, it give the following error, displaying and stop the system.
"
The constraint for referential integrity links a file found on a HyperFileSQL server to a file that does not use the Client/Server mode. This is not allowed.
Error code: 74003
Level: fatal error (EL_FATAL)
WD55 error code: 4003
"
How to correct it
Thanks in advance
BG
Signaler
0
0
GuenterP
#2
Posté le 17 septembre 2014 - 16:57
Hi, there are at least two linked files on two different 'servers', means at least 'drives'. Frequently, programmers take the invitation of setting the file location within the analysis. As it seems, at least for one of the files in your HFSQL-database the location differs from the other files.
Recommended procedure: set all the file locations in the analysis to 'HF Classic' and connect within your program to all of the files in the database on the desired server.
Signaler
0
0
Piet van Zanten
#3
Posté le 17 septembre 2014 - 18:15
Hi BG,
In addition, if Guenters solution does not work, you can also open the HFSQL Control Centre, select the database, and check the radio "Links" in the Description tab.
In the "Between" and "And" column you can check the path of each link.
There's an icon in the last column to delete faulty links.
After that you can synchronize the structure of the deployed data files and the analysis to rebuild the links. (using WDmodfic or directly from the WX analysis editor)
Regards,
Piet
Signaler
0
0
GuenterP
#4
Posté le 17 septembre 2014 - 19:26
Hi Piet, you are right! This is still a problem of frequent changes / restuctures of the database analysis.
Signaler
0
0
BG
#5
Posté le 17 septembre 2014 - 20:42
Hello,
Guenter Predl, Piet, Guenter Predl
While changes / restructures of the database analysis, one of the table change its status to CS to HF Classic but status shows as HFCS. After refreshing only it changes its status correctly..
Thanks all
BG
Signaler
0
0
→ Revenir à WINDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (précédentes versions)
Français
English
Español
Portuguesa
Fermer cette fenêtre
Type de recherche
Uniquement les sujets
Tous les messages
Période de recherche
Date indifférente
Moins d'une heure
Moins de 24 heures
Moins d'une semaine
Moins d'un mois
Moins d'un an
Annuler
Aperçu de votre message
Ajouter une image
Importer une image depuis une URL
Envoyer une image depuis un fichier de votre disque
Déposez ici un fichier ou cliquez sur "Parcourir..."
ou
Annuler
0%
WLangage
SQL
XML, HTML
JAVA, Javascript
Texte