pcsoft.us.windevCopyright 2026, PC SOFT13 Jan 2018 10:55:00 Z12 Jan 2018 22:14:00 ZHi All, How to remove or delete the duplicate records in specific column from HFSQL using query? Or using codes? Thanks, Ech30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63997-hfsql-query-remove-duplicate-records/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63997-hfsql-query-remove-duplicate-records-64019/read.awp13 Jan 2018 10:55:00 ZHi Ech, See what I am doing. The 'Temp...' variables store the values of the current record which I Need to compare for equal…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63997-hfsql-query-remove-duplicate-records-64019/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63997-hfsql-query-remove-duplicate-records-64019/read.awpHFSQL query remove duplicate recordsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63997-hfsql-query-remove-duplicate-records-64018/read.awp13 Jan 2018 09:48:00 ZHi, you store the key of the previous record and if the next record's key is the same then delete it. Where's the problem??https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63997-hfsql-query-remove-duplicate-records-64018/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63997-hfsql-query-remove-duplicate-records-64018/read.awpHFSQL query remove duplicate recordsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63997-hfsql-query-remove-duplicate-records-64017/read.awp13 Jan 2018 08:28:00 ZHi Mit, Any sample codes to delete the duplicate records in one column. Thanks,https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63997-hfsql-query-remove-duplicate-records-64017/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63997-hfsql-query-remove-duplicate-records-64017/read.awpHFSQL query remove duplicate recordsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63997-hfsql-query-remove-duplicate-records-64016/read.awp13 Jan 2018 08:12:00 ZHi, all of your problems with queries could be fixed more easily and much faster if you employ a loop through the file and decid…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63997-hfsql-query-remove-duplicate-records-64016/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63997-hfsql-query-remove-duplicate-records-64016/read.awpHFSQL query remove duplicate recordsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63997-hfsql-query-remove-duplicate-records-64015/read.awp13 Jan 2018 06:32:00 ZAny response please. Thanks, Echhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63997-hfsql-query-remove-duplicate-records-64015/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63997-hfsql-query-remove-duplicate-records-64015/read.awpHFSQL query remove duplicate records