Hi, I tried to execute a query on a table which has a Date column. I want to add the following constraint
TABLE.DATE >= ? AND TABLE.DATE <= ? If I write Date d0 = ... Date d1 = ... cmd.where(TABLE.DATE.isMoreOrEqual(d0)); cmd.where(TABLE.DATE.isLessOrEqual(d1)); then the first constraint is removed, and only the second is valid (I know this is a between constraint). The documentation of the DBCommand.where method says <If another restriction already exists for the same column it will be replaced.> (However if I add the two constraint through the DBCommand.addWhereConstraints method, it works.) Why is the previous constraint on the same column removed, what is the logic behind it? I think it's the developers responsibility not to make mutually exclusive conditions. Or am I missing something? Thanks, Ivan
