pcsoft.us.windevCopyright 2026, PC SOFT2 Jan 2016 00:54:00 Z29 Dec 2015 00:02:00 ZHello All The query editor runs out of puff after about 8 joins and refuses to add any more, so I have used the first query as the base data for a second query so I can add more joins. It all seems to work ok, but I am wondering if there are any pitfalls in using queries in this manner that I am not aware of ? Regards Al30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55711/read.awp2 Jan 2016 00:54:00 ZHello Derek It is getting clearer now. Thanks you for the sql teaching site link, it is a very good reference site for me. …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55711/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55711/read.awp[WD20] Is running a query on a query good policy ?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55708/read.awp1 Jan 2016 12:25:00 ZGreat explanation by Arie IMHO the query generator went south when it was changed to accommodate the current SQL format (v18 ii…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55708/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55708/read.awp[WD20] Is running a query on a query good policy ?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55706/read.awp31 Dec 2015 22:57:00 ZHello Arie Thanks for the code simplification, I will give it a go. Regards Alhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55706/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55706/read.awp[WD20] Is running a query on a query good policy ?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55693/read.awp31 Dec 2015 11:13:00 ZAl, I don't know when of why de WD query editor 'creates' left joins at day 1 and right joins on other moment. That's done be…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55693/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55693/read.awp[WD20] Is running a query on a query good policy ?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55691/read.awp30 Dec 2015 22:38:00 ZHello All Thanks for all the replies - it looks like I should use HExecuteSQLQuery. The problem is that I really should go aw…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55691/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55691/read.awp[WD20] Is running a query on a query good policy ?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55689/read.awp30 Dec 2015 17:59:00 ZHi A1, I highly not recommend to do 2 query unless you have no choice. i just run a test and found this method is not reco…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55689/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55689/read.awp[WD20] Is running a query on a query good policy ?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55688/read.awp30 Dec 2015 17:26:00 ZAl I have not got a query that requires 8+ joins so I may, not for the first time I might add, be barking up the wrong tree. …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55688/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55688/read.awp[WD20] Is running a query on a query good policy ?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55685/read.awp30 Dec 2015 13:17:00 ZHello Arie After the 8 + joins the query wizard returns with a message that it can't work out the connections and then it get…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55685/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55685/read.awp[WD20] Is running a query on a query good policy ?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55683/read.awp30 Dec 2015 12:25:00 ZHi Al, you can also modify the code of the SQL in the query editor (press F2). Then you lose the visual presentation, but ma…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55683/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55683/read.awp[WD20] Is running a query on a query good policy ?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55682/read.awp30 Dec 2015 12:19:00 ZHello Piet Thanks for the info, much better than starting from scratch. Regards Alhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55682/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55682/read.awp[WD20] Is running a query on a query good policy ?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55681/read.awp30 Dec 2015 11:53:00 ZHi Al, You can use the editor to create your basic query and then copy the code to use it by hExecuteSQLquery. Then you can …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55681/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55681/read.awp[WD20] Is running a query on a query good policy ?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55680/read.awp30 Dec 2015 11:35:00 ZHello CCC2 For the moment I am happy using the SQL wizard but as I get bettter at queries I will try writing my own and run t…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55680/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55680/read.awp[WD20] Is running a query on a query good policy ?supportpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55659/read.awp29 Dec 2015 11:04:27 ZHi All, [WD18] I use frequently a query on a query as it can help finetuning performance when you know how to query with the …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55659/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55659/read.awp[WD20] Is running a query on a query good policy ?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55657/read.awp29 Dec 2015 09:19:00 ZHi Al, I used that method before in one of my program , just make sure to check if there are any records in the first query b…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55657/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55655-wd20-running-query-query-good-policy-55657/read.awp[WD20] Is running a query on a query good policy ?