PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

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
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
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.
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
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.
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