pcsoft.us.windevCopyright 2026, PC SOFT31 May 2017 18:23:00 Z30 May 2017 15:56:00 ZHi I have a SAAS app . User logs in in main db In main db his db's are listed. He chooses one and based on that I close the connection to the main db and open the client db. Ok this goes fine but every now and then I get a strange bug: If I want to add a client adres for instance I fhave a client table called: "Klant" And I have a client-adres table called : "Klantadres" reading and mutating this Klant table goes just fine . But if I want to add something and odd error steps in : Error returned by server: Integrity error. The "test\klanten.fic" path is not found in the wdsoft database. WL call: Process of 'Click of BTN_Oplsaan_klantadres ( POPUP_nieuw_klantadres ) (server)' (PAGE_klanten.POPUP_nieuw_klantadres.BTN_Oplsaan_klantadres), line 50, thread 0 'HAdd' function, syntax 1 What happened? Error returned by server: Integrity error. The "test\klanten.fic" path is not found in the "wdsoft" database. Error code: 74005 Level: fatal error WD55 error code: 4005 Dump of the error of 'WDHFSRV64.DLL' module (22.0.87.3). Identifier of detailed information (.err): 73261 Debugging information: IEWDHFSRV=51.5 Module=WDHFSRV Version=22.0.87.3 Fonction (7,0) Additional Information: EIT_TYPE_WDFILE : 65538 EIT_IDCODE : 851984 EIT_SERVEURCS : localhost EIT_LOGICALTABLENAME : klantadres> EIT_PILEWL : Click of BTN_Oplsaan_klantadres ( POPUP_nieuw_klantadres ) (server) (PAGE_klanten.POPUP_nieuw_klantadres.BTN_Oplsaan_klantadres), line 50 EIT_DATEHEURE : 30/05/2017 15:30:21 (25, ERR_MSG_BO Strange thing is that "Test"is the name of an other db If Ichange something to the klant adres table and let the analysis be generated again then there is no eror all goes fine. I have come to the conclusion that It must have something to do with deleting the old connection and opening the new connection. My code to change connection: // if there is a db to choose form in the table ad stuff to a variabele IF HReadSeekFirst(Administratie,AdministratieID,TABLE_administraties.COL_ID) THEN gstrDbUser = Administratie.dbuser gstrDbPassword = Administratie.dbpaswoord gstrDbDatabase = Administratie.dbdatabase gstrDbDataSource = Administratie.dbServer HCloseConnection(MyConnection) //Add variabeles // Describe the connection MyConnection..User = gstrDbUser MyConnection..Password = gstrDbPassword MyConnection..Server = gstrDbDataSource MyConnection..Database = gstrDbDatabase MyConnection..Provider = hAccessHFClientServer MyConnection..Access = hOReadWrite // open the new connection HOpenConnection(MyConnection) IF NOT HChangeConnection("*",MyConnection) THEN EndProgram(ErrorInfo()) END HReadFirst(werkjaar,werkjaarID) IF HReadSeekFirst(Boekjaar,BoekjaarID,werkjaar.BoekjaarID ) THEN gnAdminjaar = Boekjaar.Jaar RTA_Admin = "Administratie: "+ gstrDbDatabase +"( "+ Boekjaar.Jaar+ " )" END PageDisplay(PAGE_start) If I change something inthe analyse. Like adding a field or changing a field then this faults are gone and it works just fine. But after few days same fault ) Anyone an Idea what this might be regards Allard30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection-61070/read.awp31 May 2017 18:23:00 ZHi Allard, you should read my answer again. I NEVER said that you should not use link. I just said that you CAN not use th…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection-61070/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection-61070/read.awpstrage bug when changing connectionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection-61068/read.awp31 May 2017 17:21:00 ZHi Fabrice, Indeed you are right. I used to define the db tables in hyperfile classic. If so then not all the links are add…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection-61068/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection-61068/read.awpstrage bug when changing connectionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection-61066/read.awp31 May 2017 16:58:00 ZHi Allard, this integrity constraints are NOT automatic. They are defined by YOU in the analysis, each time you define a link…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection-61066/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection-61066/read.awpstrage bug when changing connectionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection-61064/read.awp31 May 2017 15:28:00 ZI also had this problem in the past. Since a few years i disabled the usage of the .REP file and i have never had this again. …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection-61064/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection-61064/read.awpstrage bug when changing connectionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection-61063/read.awp31 May 2017 14:38:00 ZHi Joris, Indeed. huh I found out that it is managed automatiicly. Can't do anything about it... Hmm Maybe one more reason t…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection-61063/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection-61063/read.awpstrage bug when changing connectionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection-61062/read.awp31 May 2017 12:34:00 ZHi Allard, When using HFCS, the constraints are managed by the database, not by your executable (like in classic HF). Because…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection-61062/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection-61062/read.awpstrage bug when changing connectionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection-61055/read.awp30 May 2017 23:04:00 ZHi Joris Yes indeed that is the case. I havenot looked at this ever befor and I donnot know what this means?? what Am I…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection-61055/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection-61055/read.awpstrage bug when changing connectionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection-61052/read.awp30 May 2017 19:01:00 ZHi , integrity constraints in the hyperfile control center?? where can I find that ? regards Allardhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection-61052/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection-61052/read.awpstrage bug when changing connectionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection-61050/read.awp30 May 2017 16:58:00 ZHi, I doubt if it is a bug when changing connections... Did you already check the integrity constraints in the hyperfile c…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection-61050/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61049-strage-bug-when-changing-connection-61050/read.awpstrage bug when changing connection