pcsoft.us.windevCopyright 2026, PC SOFT14 Sep 2016 13:18:10 Z9 Sep 2016 17:23:00 ZHello, In a software that was running properly for a year. Now all of a sudden it has started giving this error. The file in question has only 5218 rows in all. Here is the Debug dump: What happened? Duplicates found for key on file. Error code: 70010 Level: non-fatal error (EL_ONRETURN) WD55 error code: 10 Dump of the error of 'WD170HF.DLL' module (17.0.161.3). Identifier of detailed information (.err): 70907 Debugging information: IEWDHF=30.18 Module= Version=<17.0.161.3> Additional Information: EIT_LOGICALTABLENAME : EIT_ITEMNAME : EIT_PATHFIC : EIT_PATHNDX : I am also attaching screen shot of the exception as shown by WD. [attachment 2144 2016-09-09_204731.jpg] Please help solve this problem. TIA Yogi Yang30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)Attlebaxpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic-59547/read.awp14 Sep 2016 13:18:10 ZI had something similar. It's caused when something goes wrong with something else outside Windev when it was trying to work wit…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic-59547/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic-59547/read.awp[WM17] - Duplicate ID error in HFSQL Classicguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic-59533/read.awp13 Sep 2016 12:10:00 ZArie, Thanks for the hint. I did nto erase the file but I erased all the records from file and now it is working properly.…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic-59533/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic-59533/read.awp[WM17] - Duplicate ID error in HFSQL Classicguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic-59513/read.awp12 Sep 2016 09:28:00 ZTo me it looks like your datafile is damaged in some way. Reindex did not help you said. Try deleting the whole file and start …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic-59513/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic-59513/read.awp[WM17] - Duplicate ID error in HFSQL Classicguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic-59512/read.awp12 Sep 2016 08:56:00 ZIn your screenshot you have selected the wrong item (it is a date field), select the first item and then the options get active.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic-59512/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic-59512/read.awp[WM17] - Duplicate ID error in HFSQL Classicguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic-59514/read.awp12 Sep 2016 08:51:00 ZHello King, Thanks for your inputs. But how do I do that? Here is the screen shot: [attachment 2146 2016-09-12_122015.…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic-59514/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic-59514/read.awp[WM17] - Duplicate ID error in HFSQL Classicguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic-59507/read.awp10 Sep 2016 15:05:00 ZHi If I were you, I'd use "jw_id" INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT instead of "jw_id" INTEGER PRIMARY KEY…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic-59507/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic-59507/read.awp[WM17] - Duplicate ID error in HFSQL Classicguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic-59506/read.awp10 Sep 2016 07:31:00 ZOh! BTW my PC is Core i5 with 8 GB RAM and 600 GM HDD 40% of which is empty. TIA Yogi Yanghttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic-59506/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic-59506/read.awp[WM17] - Duplicate ID error in HFSQL Classicguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic-59505/read.awp10 Sep 2016 07:05:00 ZHello Fabrice, Thanks for your inputs. None of what you have said seem to apply. I have never used anything like hfixedautoID…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic-59505/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic-59505/read.awp[WM17] - Duplicate ID error in HFSQL Classicguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic-59502/read.awp9 Sep 2016 20:01:00 ZHi two possible cases: 1. Your code is creating the problem by using hadd/hmodify with hfixedautoID or hForceAutoID option…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic-59502/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59500-wm17-duplicate-error-hfsql-classic-59502/read.awp[WM17] - Duplicate ID error in HFSQL Classic