pcsoft.us.windevCopyright 2026, PC SOFT18 Oct 2017 03:55:00 Z10 Oct 2017 15:51:00 ZI am importing data from an Excel file into my database. In the process I encounter duplicates that I want to ignore. I am using the following code (after assigning the values): IF HAdd(BVS_BOSS_LOAD) = False THEN IF HErrorDuplicates() = True THEN CONTINUE END ELSE CONTINUE END All I need is that the process to ignore the duplicate record and continue with the next record but it pops up a duplicate record screen. THNX !! JoeMaldo30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62902-how-prevent-duplicate-record-screen/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62902-how-prevent-duplicate-record-screen-62976/read.awp18 Oct 2017 03:55:00 ZGuys, Thank you for your help! I solved the problem!!https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62902-how-prevent-duplicate-record-screen-62976/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62902-how-prevent-duplicate-record-screen-62976/read.awpHow to prevent the Duplicate Record screen?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62902-how-prevent-duplicate-record-screen-62906/read.awp10 Oct 2017 17:13:00 ZhOnError(BVS_BOSS_LOAD,hErrDuplicates,"SkipDUpes") ... Loop start ... IF HAdd(BVS_BOSS_LOAD) = False THEN CONTINUE END EN…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62902-how-prevent-duplicate-record-screen-62906/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62902-how-prevent-duplicate-record-screen-62906/read.awpHow to prevent the Duplicate Record screen?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62902-how-prevent-duplicate-record-screen-62907/read.awp10 Oct 2017 16:52:00 ZHi you can either : - do a hreadseek first and do the hadd only if not there - or DEACTIVATE the automatic error handling o…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62902-how-prevent-duplicate-record-screen-62907/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62902-how-prevent-duplicate-record-screen-62907/read.awpHow to prevent the Duplicate Record screen?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62902-how-prevent-duplicate-record-screen-62904/read.awp10 Oct 2017 16:16:00 ZHi Jose, I'm doing this all the time! No such messages ... The trick is to take a peek into the file before saving anythin…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62902-how-prevent-duplicate-record-screen-62904/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62902-how-prevent-duplicate-record-screen-62904/read.awpHow to prevent the Duplicate Record screen?