pcsoft.us.windevCopyright 2026, PC SOFT22 Jan 2016 07:45:00 Z21 Jan 2016 06:19:00 ZHi We've just imported a heap of location records from an old DBase file into HFSQL & there are a lot of duplicates. I thought the easiest way to do this would be a quick SQL script in the control centre. The following works & returns the records which should be deleted SELECT * FROM LOCATION WHERE LocationId NOT IN (SELECT MIN(LocationID) FROM LOCATION GROUP BY POSTCODE,DESCRIPTION,LATITUDE,LONGITUDE) However if I replace SELECT * with DELETE I get an error "No analysis opened: LOCATION file not described". Doesn't make any sense to me as it's all in the HF Control Centre anyway! I can easily write a little routine to do the de-duplication another way but what I thought would be a 5 minute job has certainly not turned out that way. Any thoughts? Thanks David30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55962-duplicating-records/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55962-duplicating-records-55985/read.awp22 Jan 2016 07:45:00 ZWithout testing or checking, it sounds like the HFSQL DELETE function can not parse sub-selects. In the old days, I would select…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55962-duplicating-records-55985/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55962-duplicating-records-55985/read.awpDe-Duplicating Records