pcsoft.us.windevCopyright 2026, PC SOFT1 Sep 2015 18:09:00 Z30 Aug 2015 16:41:00 ZHi, in my project I have a monster query (created with the query editor) Some of these parameters should be dynamic, thats means that they can be different in special scenarios. For example: The number of a drawing in a architecture project has the following format "AAABBBCCC" AAA= house number BBB= company number CCC=status number In another project it has such a format "AABBBBCC" and so on. I save the drawing number schema in a table and build the query parameters to select the different elements of the drawing number at runtime. My first idea was to use this query and run this without the dynamic part (HExecuteQuery). The second query (based on the first query) is created with the dynamic parameters (HExecuteSQLQuery). So can I use the query editor for 90 % of the parameters. Works so far. The problem is: If the user needs only the dynamic parameters the first query returns the full table content (+100.000 records) and only the second query reduce it. The whole process is to slow. Any ideas how to put that in one query without loosing the comfort of the query editor ? My hope was, that Myquery..Sqltext give me the Sql text with the content of all the parameters at runtime but it doesn´t. HExecuteSQLQuery doesn´t allow me to use parameters so I have replace all parameters with the correct notation and thats a lot ...30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53807/read.awp1 Sep 2015 18:09:00 ZHi Piet, yes I know. But my Query has approx. 100 different parameters and I was hoping to avoid this ...https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53807/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53807/read.awp[WX20] Need ideas for dynamic query generationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53790/read.awp1 Sep 2015 00:38:00 ZMaybe out on a limb here.. If you have a key field in the drawing file that is used to look up the schema, then this should work…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53790/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53790/read.awp[WX20] Need ideas for dynamic query generationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53776/read.awp31 Aug 2015 11:02:00 ZHi Michael, It's not too hard to use hExecuteSQLquery and Stringbuild to generate tailor made queries. First you can use the…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53776/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53776/read.awp[WX20] Need ideas for dynamic query generationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53772/read.awp31 Aug 2015 09:35:00 ZYes, you got it. I have a table "drawingnumberschema", which has the following structure: From Length Description -------…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53772/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53772/read.awp[WX20] Need ideas for dynamic query generationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53770/read.awp31 Aug 2015 08:46:00 ZHi, if I understand it correctly, you need to define the different parts of the drawingnummer of every project. Based on thes…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53770/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53770/read.awp[WX20] Need ideas for dynamic query generationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53765/read.awp30 Aug 2015 20:40:00 ZHi again I still don't understand... The fixed part (in the file) is a string... It's content depend on the user defined s…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53765/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53765/read.awp[WX20] Need ideas for dynamic query generationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53763/read.awp30 Aug 2015 19:32:00 ZHi Michael, you could read all drawings in an array at program start. If the user searches for one parameter you search the a…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53763/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53763/read.awp[WX20] Need ideas for dynamic query generationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53762/read.awp30 Aug 2015 19:26:00 Z...and house number and company number are examples. These are not existent in all projects. my drawing number field is a str…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53762/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53762/read.awp[WX20] Need ideas for dynamic query generationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53761/read.awp30 Aug 2015 19:19:00 ZHi, of course your example should be work. And of course I simplified my example. In fact I need for every part from the d…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53761/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53761/read.awp[WX20] Need ideas for dynamic query generationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53760/read.awp30 Aug 2015 19:07:00 ZHi Michalely.. One more thought, if you are using HFCS, you maybe able to programmatically generate separate query fields for…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53760/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53760/read.awp[WX20] Need ideas for dynamic query generationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53759/read.awp30 Aug 2015 18:35:00 ZHi Michalely.. I'm sorry to hear that. If a LIKE {param1} doesn't work for you where Param1 is generated at run time, then I …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53759/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53759/read.awp[WX20] Need ideas for dynamic query generationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53758/read.awp30 Aug 2015 17:47:00 ZHi Blacky, it doesn´t work. I don´t know these conditions at designt time. The user creates the format and lenght of the draw…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53758/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53758/read.awp[WX20] Need ideas for dynamic query generationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53757/read.awp30 Aug 2015 17:43:00 ZHi Fabrice, the problem is, that I doesn´t know all parameters at design time. Look at my example. My program is used in d…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53757/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53757/read.awp[WX20] Need ideas for dynamic query generationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53756/read.awp30 Aug 2015 17:36:00 ZAssuming that drawing number is a text/string field in of your tables, then using the query editor and creating a condition wher…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53756/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53756/read.awp[WX20] Need ideas for dynamic query generationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53755/read.awp30 Aug 2015 17:24:00 ZHello Michael I do not understand what the problem is. The query editor supports of course dynamic parameters in the conditi…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53755/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53750-wx20-need-ideas-for-dynamic-query-generation-53755/read.awp[WX20] Need ideas for dynamic query generation