pcsoft.us.windevCopyright 2026, PC SOFT16 Sep 2016 16:18:00 Z16 Sep 2016 13:49:00 ZDear fellow windev developers, I am hoping someone can help point me in the right direction with an issue when changing database table connections. I have an application that uses a hyperfile classic analysis with files locally in the executable directory. This all works absolutely fine. Within this analysis I have links for relationships between some of the tables. I want to change the source location for 95% of these tables to a HFCS Client/Server which I have already setup and with the following commands I am able to do this for any table that has no links. Server is Connection // Parameters of the connection Server..Provider = hAccessHFClientServer Server..User = "Admin" Server..Password = "" Server..Server = "RLSXPS1:4900" Server..Database = "FRM" Server..CryptMethod = hCryptNo // Opening the connection IF HOpenConnection(Server) = False THEN Info(HErrorInfo(hErrFullDetails)) END IF HChangeConnection(FreeText,Server)= False THEN Info(HErrorInfo(hErrFullDetails)) ELSE HChangeDir(FreeText,".") //Info("New Connection",HNbRec(FreeText)) IF HCreationIfNotFound(FreeText) = True THEN FreeText.FreeText = "TEST" HAdd(FreeText) END END However when we try to perform this task on a table that has links we get the following error:- Error at line 24 of Global Procedure DatabaseConnect process. HCreationIfNotFound function called. The constraint for referential integrity links a file found on a HFSQL server to a file that does not use the Client/Server mode. This is not allowed. Can anyone offer some advice on how to resolve this please? Thank you for any assistance, Lee Shroder30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59597-how-move-from-classic-client-server/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59597-how-move-from-classic-client-server-59603/read.awp16 Sep 2016 16:18:00 ZThank you so much Fabrice for pointing me in the right direction, my headache has now all gone thanks to your guidance :) Lee…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59597-how-move-from-classic-client-server-59603/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59597-how-move-from-classic-client-server-59603/read.awpHow to move from classic to client/serverWinRockpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59597-how-move-from-classic-client-server-59600/read.awp16 Sep 2016 15:16:37 Zno its possible u just have to change the type of the files from the context menu->file description and select the connextion …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59597-how-move-from-classic-client-server-59600/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59597-how-move-from-classic-client-server-59600/read.awpHow to move from classic to client/serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59597-how-move-from-classic-client-server-59601/read.awp16 Sep 2016 15:04:00 ZHi Lee of course it is possible... just : 1. deactivate integrity management 2. loop on all files 3. reactivate integ…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59597-how-move-from-classic-client-server-59601/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59597-how-move-from-classic-client-server-59601/read.awpHow to move from classic to client/serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59597-how-move-from-classic-client-server-59599/read.awp16 Sep 2016 14:29:00 ZHi Joris, Thank you for your response, however the final desired result is to move all tables that have constraints to the cl…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59597-how-move-from-classic-client-server-59599/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59597-how-move-from-classic-client-server-59599/read.awpHow to move from classic to client/serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59597-how-move-from-classic-client-server-59598/read.awp16 Sep 2016 14:20:00 ZHi, Indeed, it is not possible to use a integrity constraint between a classic file and a file in client/server mode. This i…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59597-how-move-from-classic-client-server-59598/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59597-how-move-from-classic-client-server-59598/read.awpHow to move from classic to client/server