Ho to handle "---" in filter of Delete Query?
once again a question.
I got a MDO having 3 columns A B C.
In there is a dataset looking like ['a', NULL, NULL] what looks like ['a', '---', '---'] in MII.
Want to delete this using a Query.
My Fiterexpression looks like [A] = [Param.1] AND [B] = [Param.2] AND [C] = [Param.3]
Tried to pass "---", "", nothing...but nothing works.
Thanks for your support!
christian libich replied
You could try using the stringif function in the link editor when you assign your params. Something like stringif(<value>=="---", " IS NULL", " = " & <value> ) may work. I haven't used MDO that much but usually MII just does a replace of your [Param.1] so you typically can pass an '=' in the param etc.