pcsoft.us.windevCopyright 2026, PC SOFT16 Jan 2018 10:36:00 Z12 Jan 2018 13:08:00 ZHi guys, i have a problem. I have a xls with up 300.000 line and the file is 17Mb. I want to import this xls in my database. I fill a table with data found in xls, the memory of the exe is up 500Mb in this moment. I have a procedure to import the data found in the table, in this procedure i have 4 different HAdd and 6 different HModify. In the middle of the import (more or less) the program close illegally without error, the memory of the exe is up of 1800Mb. Can you help me?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-64029/read.awp16 Jan 2018 10:36:00 Zit happens in both caseshttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-64029/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-64029/read.awpWD22 - Problem on memory with HAdd()/Hmodifyguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-64028/read.awp16 Jan 2018 09:54:00 ZHi Giovanni, does this problem occurs in runtime or during testing when developing? If it is during testing, check if the …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-64028/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-64028/read.awpWD22 - Problem on memory with HAdd()/Hmodifyguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-64027/read.awp16 Jan 2018 09:33:00 ZI tried... the problem persist on 32bit version.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-64027/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-64027/read.awpWD22 - Problem on memory with HAdd()/Hmodifyguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-64025/read.awp15 Jan 2018 14:02:00 ZHi... well... your code nearly STARTS with ...HTransactionStart(WiNeMo_connection)... So I would say that the solution …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-64025/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-64025/read.awpWD22 - Problem on memory with HAdd()/Hmodifyguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-64011/read.awp14 Jan 2018 16:51:00 ZThaks Fabrice... At last how to disable transaction?https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-64011/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-64011/read.awpWD22 - Problem on memory with HAdd()/Hmodifyguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-64001/read.awp13 Jan 2018 12:47:00 ZOK, so we can forget everything about excel... Let see If I understand the original question now... So, tell me if I'm rig…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-64001/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-64001/read.awpWD22 - Problem on memory with HAdd()/Hmodifyguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-64000/read.awp13 Jan 2018 09:43:00 ZUpdate: i have test my code from yesterday i have uderstand that the problem is not Hadd()/Hmodify. Now i think the proble…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-64000/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-64000/read.awpWD22 - Problem on memory with HAdd()/Hmodifyguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-63995/read.awp12 Jan 2018 19:16:00 ZI have a problem when process the data file.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-63995/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-63995/read.awpWD22 - Problem on memory with HAdd()/Hmodifyguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-63992/read.awp12 Jan 2018 18:56:00 ZNow I'm confused... do yo have the problem when importing the xls into a DB file, or later, when processing the DB file itsel…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-63992/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-63992/read.awpWD22 - Problem on memory with HAdd()/Hmodifyguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-63987/read.awp12 Jan 2018 16:39:00 Z*Gianni I have to use my tool becouse this import can be runned from the end user. *Facrice The code with the problem i…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-63987/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-63987/read.awpWD22 - Problem on memory with HAdd()/Hmodifyguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-63982/read.awp12 Jan 2018 13:58:00 ZHello Gianni I suggest you to import directly the xls records using an external tool like SqlYOG. (I suppose you are using M…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-63982/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-63982/read.awpWD22 - Problem on memory with HAdd()/Hmodifyguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-63981/read.awp12 Jan 2018 13:54:00 ZHi Giovanni, if I remember correctly, xls files were originally limited to 65535 lines. Now, recent excel versions can manage…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-63981/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63979-wd22-problem-memory-with-hadd-hmodify-63981/read.awpWD22 - Problem on memory with HAdd()/Hmodify