pcsoft.us.windevCopyright 2026, PC SOFT13 May 2015 14:26:00 Z12 May 2015 16:16:00 ZHello, something weird happens when I paste a query in webdev 20 and the program stops working. The syntax of the query is correct, since I have tested it in SQL Server. However, even if it was not correct, why would webdev stop working???? It is driving me crazy. I am posting the query as well, even though it will be of little use since you don't know what analysis I am using: SELECT t.niveli_organigram,t.kodi,COUNT(t.kodi) AS sasia_sherbimit,t.emertimi FROM ( SELECT s.niveli_organigram,(SELECT label FROM ips_service_types WHERE id=s.id_sherbimit) AS kodi,(SELECT name FROM ips_service_types WHERE id=s.id_sherbimit) AS emertimi FROM ( SELECT DISTINCT A.id AS id_aplikimit,r.niveli_organigram,art.svet_id AS id_sherbimit FROM ips_user_application_steps s,ips_applications AS A,ips_application_requests AS art, (SELECT ips_organisation_elements.ogn_level AS niveli_organigram,ips_user_organigram_positions.usr_id FROM ips_user_organigram_positions,ips_organisation_elements,ips_users,ips_applications WHERE ips_organisation_elements.id=ips_user_organigram_positions.org_id AND ips_users.id=ips_user_organigram_positions.usr_id AND ips_users.activ=1 AND ips_users.end_date IS NOT NULL ) AS r WHERE r.usr_id=s.usr_id AND A.id=s.apn_id AND A.application_date >='2013-10-30' AND A.application_date<='2014-01-30' AND A.ast_id NOT IN (1000000,1000007,1000016) AND art.apn_id=A.id AND r.niveli_organigram LIKE '001%') AS s) t GROUP BY t.niveli_organigram,t.kodi,t.emertimi30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52055-webdev-20-stops-working-when-paste-query/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52055-webdev-20-stops-working-when-paste-query-52074/read.awp13 May 2015 14:26:00 ZHi okay, now we know what's going on... So the problem is: when you paste it in the query editor, the editor tries to ret…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52055-webdev-20-stops-working-when-paste-query-52074/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52055-webdev-20-stops-working-when-paste-query-52074/read.awpwebdev 20 stops working when I paste a queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52055-webdev-20-stops-working-when-paste-query-52064/read.awp13 May 2015 08:14:00 ZI am pasting it in the query editor.... However, I tried to paste it in the code (as a string) and text file as well and I used…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52055-webdev-20-stops-working-when-paste-query-52064/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52055-webdev-20-stops-working-when-paste-query-52064/read.awpwebdev 20 stops working when I paste a queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52055-webdev-20-stops-working-when-paste-query-52061/read.awp12 May 2015 19:05:00 ZHi Kozeta, Adding to Fabrice, you say you are using HExecuteQuery() so must we understand that this is a query you made in th…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52055-webdev-20-stops-working-when-paste-query-52061/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52055-webdev-20-stops-working-when-paste-query-52061/read.awpwebdev 20 stops working when I paste a queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52055-webdev-20-stops-working-when-paste-query-52060/read.awp12 May 2015 17:47:00 ZHi you are saying that you are pasting the query in webdev, but you are not saying WHERE in webdev, and webdev is a big place…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52055-webdev-20-stops-working-when-paste-query-52060/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52055-webdev-20-stops-working-when-paste-query-52060/read.awpwebdev 20 stops working when I paste a queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52055-webdev-20-stops-working-when-paste-query-52059/read.awp12 May 2015 17:00:00 ZThank you Alexandre, I will see what I can do....It does not have errors since everything goes well when I test it on SQL Server…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52055-webdev-20-stops-working-when-paste-query-52059/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52055-webdev-20-stops-working-when-paste-query-52059/read.awpwebdev 20 stops working when I paste a queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52055-webdev-20-stops-working-when-paste-query-52058/read.awp12 May 2015 16:50:00 ZHi Kozeta, Split your request and and test each part. Then add a layer of complexity. When you have many nested selects, anyt…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52055-webdev-20-stops-working-when-paste-query-52058/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52055-webdev-20-stops-working-when-paste-query-52058/read.awpwebdev 20 stops working when I paste a queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52055-webdev-20-stops-working-when-paste-query-52057/read.awp12 May 2015 16:40:00 ZI will use HexecuteQuery("query_name","connection_name",hRequêteSansCorrection)... However it doesn't let me save it , let alon…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52055-webdev-20-stops-working-when-paste-query-52057/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52055-webdev-20-stops-working-when-paste-query-52057/read.awpwebdev 20 stops working when I paste a queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52055-webdev-20-stops-working-when-paste-query-52056/read.awp12 May 2015 16:32:00 ZDid you use that SQL to create a WinDev-query or are you using HExecuteSQLQuery() to run the query?https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52055-webdev-20-stops-working-when-paste-query-52056/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52055-webdev-20-stops-working-when-paste-query-52056/read.awpwebdev 20 stops working when I paste a query