HomeActive Query BuilderProgramatic condition

Programatic condition

I'm trying to insert the following condition programmaticaly:

WHERE (A not in (a,b) AND B not in (c,d)) OR B in (e,f)

I have something like this:

A.ConditionStrings[0] = "not in (a,b)"
B.ConditionStrings[0] = "not in (c,d)"
B.ConditionStrings[1] = "not in (e,f)"

This works fine when it's the only condition, but if the query contains other condition, then it doesn't necessarely return the right data.

Any idea how I can add such a condition without messing up the rest?
Pierre Alain | email
February 21 2011, 10:28 AM
This topic is closed