pcsoft.us.windevCopyright 2026, PC SOFT16 Feb 2011 11:28:33 Z15 Feb 2011 11:42:14 ZHello, i want to use an insertquery in windev and then immeadiately ask the inserted key. I know i can do it by "max" but is it realy this inserted key that he returns.. Imagine when someone else inserts on the same moment a key and you ask for the max. How can you be sure that the id is your inserted key. hexecutequery(INSERTQUERYNAME) thanks30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/30754-windev-insert-query-get-last-inserted/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/30754-windev-insert-query-get-last-inserted-found-30774/read.awp16 Feb 2011 11:28:33 Zwith retrieveitem it works , but not on the queryname but on the table itself. lastInsertedRecord is string = HRetrieveItem(Tab…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/30754-windev-insert-query-get-last-inserted-found-30774/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/30754-windev-insert-query-get-last-inserted-found-30774/read.awpWindev : insert query + get last inserted idguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/30754-windev-insert-query-get-last-inserted-30759/read.awp15 Feb 2011 16:49:55 ZI tried to : qry_AddStop.ParamSoortnr = IncSoortNr HExecuteQuery(qry_AddStop) laatstestop is string = HRetrieveRecord(qry_Ad…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/30754-windev-insert-query-get-last-inserted-30759/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/30754-windev-insert-query-get-last-inserted-30759/read.awpWindev : insert query + get last inserted idguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/30754-windev-insert-query-get-last-inserted-30756/read.awp15 Feb 2011 14:50:05 ZHi, will this do the trick Rec is string = HRetrieveRecord(INSERTQUERYNAME) Returns the content of the current record (in a f…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/30754-windev-insert-query-get-last-inserted-30756/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/30754-windev-insert-query-get-last-inserted-30756/read.awpWindev : insert query + get last inserted id