Dynamic Update Where Clause with "AND"

[Anonymous]

Hello,

I'm trying to achieve a dynamic update with 2 or more conditions. Can I put an "AND" in the where clause?

Example: ActiveDocument.DynamicUpdateCommand("DELETE FROM TableX WHERE Deal_ID = '1' AND Counter = '2'")

Does it work in Qlikview?

Thanks

[YoussefBelloum · Accepted solution]

Hi,

If your question is only about the AND on the where, so YES you can put AND on your where clause.

[Anonymous]

Many thanks Youssef. It worked

[YoussefBelloum]

You're welome !

Good luck