pcsoft.us.windevCopyright 2026, PC SOFT7 Aug 2016 02:56:00 Z5 Aug 2016 20:54:00 ZHi. It's hard to explain this weird thing happening.. [WD20] I created a View on MySql involving 3 tables by outer join. When executing a query via query editor on this view instead of a common MySql table the HF engine (I use HExecuteQuery with HQueryDefault option) add an ORDER BY I never wrote in the editor followed by ALL the fields of the view. The sad result is a query running 12-20 times slower in relation to its speed if run by hand via HExectuteSQLQuery with HQueryNoCorrection option. I need to use the editor to take the advantage of filter parameters (enabled or disabled by Null query parameter). It's nonsense. It's a bug of the engine?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58985-auto-quotorder-byquot-added-with-query-mysql-views/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58985-auto-quotorder-byquot-added-with-query-mysql-views-58999/read.awp7 Aug 2016 02:56:00 ZI noticed that even in simple queries on one table it appends unuseful order by clause. Is there a way to get rid of unwanted o…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58985-auto-quotorder-byquot-added-with-query-mysql-views-58999/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58985-auto-quotorder-byquot-added-with-query-mysql-views-58999/read.awpAuto "Order by" added with query on MySql viewsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58985-auto-quotorder-byquot-added-with-query-mysql-views-58997/read.awp6 Aug 2016 13:52:00 ZThanks. The general issue is that HF engine creating SQL the actual queries running on mysql always append "ORDER BY" clause ev…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58985-auto-quotorder-byquot-added-with-query-mysql-views-58997/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58985-auto-quotorder-byquot-added-with-query-mysql-views-58997/read.awpAuto "Order by" added with query on MySql viewsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58985-auto-quotorder-byquot-added-with-query-mysql-views-58996/read.awp6 Aug 2016 05:59:00 Zif you are using query editor and HExecuteQuery with HQueryDefault option , don't assume wd will send query to the server with l…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58985-auto-quotorder-byquot-added-with-query-mysql-views-58996/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58985-auto-quotorder-byquot-added-with-query-mysql-views-58996/read.awpAuto "Order by" added with query on MySql views