pcsoft.us.windevCopyright 2026, PC SOFT29 Oct 2014 14:39:00 Z28 Oct 2014 17:15:00 ZHi, Is there a way to Duplicate a Record with a Unique Key from the Control Center... easier than adding a blank record and filling it in from scratch? A popup shows the unique key outlined in Red, but changing it there doesn't help... apparently it's the original field value, and copying the record with the edited value still results in a duplicate key, and it won't allow it. I tried to Create a Temporary table on the fly with SQL to copy it there, change it and copy it back... but the Control Center doesn't recognize the word "Temporary". Thanks in Advance for any help on this...30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48688-wb19-duplicate-record/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48688-wb19-duplicate-record-48710/read.awp29 Oct 2014 14:39:00 ZHi, I realize now, this Duplicate Record feature only works in the "Content" window, not the "SQL" window when there's a Uniq…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48688-wb19-duplicate-record-48710/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48688-wb19-duplicate-record-48710/read.awp[WB19] Duplicate the Recordguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48688-wb19-duplicate-record-48707/read.awp29 Oct 2014 14:23:00 Z[attachment 1242 duplicatekey.png] Yes the area in Red is editable, however... two things: The record in the popup shows t…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48688-wb19-duplicate-record-48707/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48688-wb19-duplicate-record-48707/read.awp[WB19] Duplicate the Recordguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48688-wb19-duplicate-record-48706/read.awp29 Oct 2014 14:05:00 ZHi Randall, indeed you got an popup, with the problem key-value in red. But when I duplicate a record (with a unique key) I c…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48688-wb19-duplicate-record-48706/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48688-wb19-duplicate-record-48706/read.awp[WB19] Duplicate the Recordguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48688-wb19-duplicate-record-48705/read.awp29 Oct 2014 13:12:00 ZHi Stefan, It doesn't work when there's a unique key. I guess because copying the record would duplicate the key field, so th…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48688-wb19-duplicate-record-48705/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48688-wb19-duplicate-record-48705/read.awp[WB19] Duplicate the Recordguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48688-wb19-duplicate-record-48703/read.awp29 Oct 2014 12:00:00 ZHi Randall, if you mean the HFSQL Control Center, then right click on the record and in the context menu choose 'Duplicate th…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48688-wb19-duplicate-record-48703/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48688-wb19-duplicate-record-48703/read.awp[WB19] Duplicate the Record