pcsoft.us.windevCopyright 2026, PC SOFT18 Nov 2020 18:39:35 Z13 Nov 2020 12:30:13 ZI state to be brand new with windev, I have to create a json like this: [ { "cassa": "9900000000011", "importo": [ "0000000009001", "9900000000011", "000000001" ]}, { "cassa": "9900000000028", "importo": [ "0000000009002", "9900000000028", "000000002" ] } ] i try with this code: vCass is Variant vDett is Variant HExecuteQuery(QRY_testxarray,hQueryDefault) Res is Variant vXCass is int FOR EACH QRY_testxarray vXCass=QRY_testxarray.cassa HExecuteQuery(QRY_cassaTrans,hQueryDefault,vXCass) ArrayDeleteAll(vDett) FOR EACH QRY_cassaTrans Add(vDett, QRY_cassaTrans.importo) END Res.cassa=vXCass Res.Importo = vDett END Info(VariantToJSON(Res,psdFormatting)) ToClipboard(VariantToJSON(Res,psdFormatting)) but the result is that I can only get a bad record: { "cassa":53, "Importo": [ 1285, 2530, 7280 ] } the queries are correct but I probably didn't understand how to handle variables correctly30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)marcovpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries-68126/read.awp18 Nov 2020 18:39:35 ZI HAVE SOLVED x_struct is Structure ca is string imp is array of string END x is x_struct bufVbuffer is Buffer ar…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries-68126/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries-68126/read.awpCreate JSON from queriesmarcovpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries-68125/read.awp18 Nov 2020 16:35:37 Zhi Chura WALLY, the result of youir code is: [ { "cassa":2, "Importo":4000 }, { "cassa":3, "Importo":860 }, { "cassa":3, "I…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries-68125/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries-68125/read.awpCreate JSON from queriesChura WALLYpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries-68124/read.awp18 Nov 2020 00:33:31 Zhola amigo pienso que necesitas esto x is variant array_x is array of variant FOR EACH QRY_cassaTrans x.cassa =QRY_cas…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries-68124/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries-68124/read.awpCreate JSON from queriesAndrea Chiadò Piatpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries-68120/read.awp17 Nov 2020 10:16:40 ZOk, I don't know exactly what is wrong, but I think you can try to use a structure instead of a variant to fill your data from q…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries-68120/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries-68120/read.awpCreate JSON from queriesmarcovpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries-68119/read.awp16 Nov 2020 21:12:14 ZHi, the queries must be two, in my opinion the problem is that I can't create an array consisting of a field from the first quer…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries-68119/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries-68119/read.awpCreate JSON from queriesAndrea Chiadò Piatpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries-68117/read.awp16 Nov 2020 16:52:19 ZProbably you have to do something to format your query output... Anyway, have you tried HExportJSON? https://help.windev.com/e…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries-68117/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries-68117/read.awpCreate JSON from queriesmarcovpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries-68114/read.awp16 Nov 2020 14:05:37 Zi try but i have same resulthttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries-68114/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries-68114/read.awpCreate JSON from queriesmarcovpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries-68113/read.awp16 Nov 2020 11:22:19 Zhi, use the express version 25 because I would like to test some aspectshttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries-68113/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries-68113/read.awpCreate JSON from queriesAndrea Chiadò Piatpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries-68112/read.awp16 Nov 2020 09:54:55 ZHi Marco, what version of wd are you using? Because from v24 you can create a json variable directly https://help.windev.com/…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries-68112/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68108-create-json-from-queries-68112/read.awpCreate JSON from queries