pcsoft.us.windevCopyright 2026, PC SOFT26 Apr 2018 07:06:32 Z8 Nov 2016 17:21:07 ZI try to retrieve the id of the record(s) inserted with a query to no avail. The closest I've got is, from http://forum.pcsoft.fr/es-ES/pcsoft.us.windev/30754-windev-insert-query-get-last-inserted/read.awp, HRetrieveItem but first it will only get me the last record, regardless of who inserted it (if someone else added other records then this will not be good) but regardless, it does not work anyways as I am inserting the records using a transaction. My DB is MS SQL 2012 using OLEDB and the simplest code that does not work is like this: // I defined a very simple query named QRY_InsertCompany like INSERT INTO COMPANIES (NAME) VALUES ({paramName}) [code:wl] FUNCTION PRIVATE AddCompany(cCompany): int QRY_InsertCompany.ParamName = cCompany IF HExecuteQuery(QRY_InsertCompany, hWithTransaction) THEN sLastRecord is string = HRetrieveItem (Companies, 1) RESULT sLastRecord END RESULT 0 [/code] Ignoring the fact that the return value would be wrong as is a string instead of int, it will return the last record of the table but it is not the one inserted probably because of the transaction which I cannot close for I need to use this ID on other inserts, so it does not help me at all. Even if it worked, there is no guarantee that is MY record and even if all that is satisfied it will work for one record, but what if I do something like INSERT INTO COMPANIES (NAME) SELECT NEW_NAME FROM NEWCOMPANIES Or something like that, how would I retrieve all the inserted pks? (In other languages I would use the OUTPUT clause of SQL Server Insert command but I was not able to make it work with WinDev 21 and found little help TIA30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60274-retrieving-records/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)jamblard.altaiirepcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60274-retrieving-records-65310/read.awp26 Apr 2018 07:06:32 ZHello, I got the w23 42u version but still have the problem of duplicate rows during insert statement with output clause. …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60274-retrieving-records-65310/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60274-retrieving-records-65310/read.awpRetrieving ID of recordsamarretepcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60274-retrieving-records-60344/read.awp14 Nov 2016 18:48:56 ZHi Fabrice, I see that my answer is lost... Not my good month...https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60274-retrieving-records-60344/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60274-retrieving-records-60344/read.awpRetrieving ID of recordsamarretepcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60274-retrieving-records-60343/read.awp14 Nov 2016 18:25:34 ZThanks for the answer Fabrice, but I still cannot get this going, very frustrating as this should be very easy. I am sure I am n…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60274-retrieving-records-60343/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60274-retrieving-records-60343/read.awpRetrieving ID of recordsfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60274-retrieving-records-60276/read.awp8 Nov 2016 19:17:52 ZHello Hugo, to do that, if it's supported by your target DB, you need to use the SQL syntax sending back the created ID. O…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60274-retrieving-records-60276/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60274-retrieving-records-60276/read.awpRetrieving ID of records