pcsoft.us.windevCopyright 2026, PC SOFT4 Sep 2015 16:13:00 Z3 Sep 2015 21:24:00 ZI have a Barcode field that is a unique key. It's in a file called Test. If I try to add duplicate Barcodes via inline editing in the control center or by HAdd()/HModify() I get a duplicate key warning. But when I add duplicate Barcodes via an sql query I do not get a warning and the duplicate record are entered into the file. Is this supposed to happen? Shouldn't the sql code fail on account of the duplicate keys?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53858-wd20-unique-key/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53858-wd20-unique-key-53883/read.awp4 Sep 2015 16:13:00 Zoopshttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53858-wd20-unique-key-53883/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53858-wd20-unique-key-53883/read.awp[WD20] Unique Keyguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53858-wd20-unique-key-53882/read.awp4 Sep 2015 16:07:00 ZThanks Fabrice. Unfortunately I have to use queries when dealing with multiple records as it is much faster than looping throuh …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53858-wd20-unique-key-53882/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53858-wd20-unique-key-53882/read.awp[WD20] Unique Keyguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53858-wd20-unique-key-53869/read.awp4 Sep 2015 11:53:00 ZHi Curtis, Your question makes me think that you did not use the hcheckduplicates option in your hexecutequery. You should re…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53858-wd20-unique-key-53869/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53858-wd20-unique-key-53869/read.awp[WD20] Unique Keyguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53858-wd20-unique-key-53863/read.awp4 Sep 2015 06:55:00 ZHi, you have to take in account that empty barcode fields are "key values" as well and two empty barcode fields will trigger a d…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53858-wd20-unique-key-53863/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53858-wd20-unique-key-53863/read.awp[WD20] Unique Key