pcsoft.us.windevCopyright 2026, PC SOFT29 Jan 2016 15:13:00 Z29 Jan 2016 10:44:00 ZHi. I love having in query editor the ability of setting null a parameter in order to cut off a piece of condition in WHERE clause. Ex. WHERE field1 = {p1} AND field2 = {p2} where setting p1 = Null and p2 = 5 means having only WHERE field2 = 5 What if I need to make parametric an IS NULL condition? Ex. WHERE (field1 = {p1}) OR (field1 IS NULL) I need to run this WHERE even cutting off "OR field1 IS NULL" part. The goal is including or excluding NULL values for Field1 depending on what the user needs. I would use 2 different queries but often the list of fields that need this management could be 10 or more, in the same query... I did not succeed in making disappear an IS NULL condition by parameters. Is there a way to do it or should I leave the Query Editor for non-banal ordinary queries and write all these queries by hand? Thank you. Stefano30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56124-query-editor-can-make-null-condition-parametric/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56124-query-editor-can-make-null-condition-parametric-56138/read.awp29 Jan 2016 15:13:00 ZThis is easily accomplished in the query editor by creating a calculated item and entering the SQL commands that Erik's suggests…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56124-query-editor-can-make-null-condition-parametric-56138/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56124-query-editor-can-make-null-condition-parametric-56138/read.awpQuery editor: can we make IS NULL condition parametric?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56124-query-editor-can-make-null-condition-parametric-56135/read.awp29 Jan 2016 14:56:00 ZSo parametric conditions including IS NULL implies query by hand... Then it means that for using Query Editor for complex sel…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56124-query-editor-can-make-null-condition-parametric-56135/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56124-query-editor-can-make-null-condition-parametric-56135/read.awpQuery editor: can we make IS NULL condition parametric?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56124-query-editor-can-make-null-condition-parametric-56134/read.awp29 Jan 2016 14:32:00 ZHi, This would be my approach too. A little remark on Eriks code: include the "WHERE" in the condition strings, so if you le…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56124-query-editor-can-make-null-condition-parametric-56134/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56124-query-editor-can-make-null-condition-parametric-56134/read.awpQuery editor: can we make IS NULL condition parametric?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56124-query-editor-can-make-null-condition-parametric-56127/read.awp29 Jan 2016 12:03:00 ZHi Stefano, if I understand correct, what I am doing in this case: creating a string variable and fill it with the query. …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56124-query-editor-can-make-null-condition-parametric-56127/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56124-query-editor-can-make-null-condition-parametric-56127/read.awpQuery editor: can we make IS NULL condition parametric?guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56124-query-editor-can-make-null-condition-parametric-56125/read.awp29 Jan 2016 10:50:00 ZPS. It seems that my question is similar or slightly related to a recent one make by DannHCS. The topic is the same, I'm not s…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56124-query-editor-can-make-null-condition-parametric-56125/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56124-query-editor-can-make-null-condition-parametric-56125/read.awpQuery editor: can we make IS NULL condition parametric?