pcsoft.us.windevCopyright 2026, PC SOFT5 Nov 2015 16:05:00 Z4 Nov 2015 06:00:00 ZI have a query in which there are multiple parameters. Depending on user selection I want to set some parameters with a value and some without any value so that they do not have any effect on the output of the query. Here is the query: SELECT student_master.sm_id AS sm_id, student_master.sm_student_name AS sm_student_name, student_master.sm_gr_no AS sm_gr_no, enrollment.enrollment_roll_no AS enrollment_roll_no, student_master.sm_gender AS sm_gender, student_master.sm_performance_benchmark AS sm_performance_benchmark FROM enrollment, student_master WHERE enrollment.enrollment_sm_id = student_master.sm_id AND ( enrollment.enrollment_ay_id = {ParamAcademicYear} AND enrollment.enrollment_std_id = {ParamStdID} AND enrollment.enrollment_div_id = {ParamDivID} ) Here for example if a user selects the Standard then I just want to set the {ParamStdID} to a value and make others null. How to achieve this? If I try to set the other parameters to null it get error at run time. TIA Yogi Yang30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54854/read.awp5 Nov 2015 16:05:00 ZLooking at the Help, it was introduced at V16, but that was probably into WD? If it's not avaiable in your version of WM, I w…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54854/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54854/read.awp[WX17] - How to set null parameters in an Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54852/read.awp5 Nov 2015 15:57:00 ZDarren, I tried the the HFreeQuery route but in case of WM17 it gives error in the final Android at run time. TIAhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54852/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54852/read.awp[WX17] - How to set null parameters in an Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54851/read.awp5 Nov 2015 15:52:00 ZArie, I have two windows. In one the user selects the criteria which are displayed as combo boxes. Here is the screen shot…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54851/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54851/read.awp[WX17] - How to set null parameters in an Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54850/read.awp5 Nov 2015 15:50:00 ZHey Yogi, If you issue a HFreeQuery beforehand, you shouldn't need the "= Null" lines of code. HFreeQuery is the easiest/safe…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54850/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54850/read.awp[WX17] - How to set null parameters in an Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54849/read.awp5 Nov 2015 15:35:00 ZDarren, I think I have found my answer from your reply. But just for clarifications. Will this code work? IF AY > 0 THEN …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54849/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54849/read.awp[WX17] - How to set null parameters in an Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54841/read.awp5 Nov 2015 09:33:00 ZYogi, I have a pretty complex query and a set of fields and drop-downs where the user selects and enters various values and h…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54841/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54841/read.awp[WX17] - How to set null parameters in an Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54839/read.awp5 Nov 2015 09:08:00 ZYogi, there are several ways to present the query data, can you give us more details? In my apps I use queries this way almo…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54839/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54839/read.awp[WX17] - How to set null parameters in an Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54838/read.awp5 Nov 2015 08:00:00 ZHi yogi, This is I guess normal behavior. You cannot use a querie over and over again. You can but moast likely get unexpecte…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54838/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54838/read.awp[WX17] - How to set null parameters in an Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54836/read.awp5 Nov 2015 05:49:00 ZArie and Danner, Thanks for your inputs but I have to use the same query again and again with different parameters. Let me…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54836/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54836/read.awp[WX17] - How to set null parameters in an Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54822/read.awp4 Nov 2015 11:15:00 Z...further to Arie's response, if you need to re-execute the query, I tend to issue a HFreeQuery to free up system resources but…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54822/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54822/read.awp[WX17] - How to set null parameters in an Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54818/read.awp4 Nov 2015 08:53:00 ZYogi, then just don't fill in those parameters. Suppose your query is named Query1 and you records with stdid=3 then do this: …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54818/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54815-wx17-how-set-null-parameters-query-54818/read.awp[WX17] - How to set null parameters in an Query