Querybuilder Bug

[morgande]

Hello after using the querybuilder it suggested this

…….

WHERE (a.col1 <'2007-31-01' AND b.col2 !=0 AND c.col2 !=0 AND d.col3 =1)

OR (d.col3 =4)

GROUP BY a.col4;

……. But it shouldn't it really be

WHERE (a.col1 <'2007-31-01' AND b.col2 !=0 AND c.col2 !=0)

AND (d.col3 =1 OR d.col3 =4)

GROUP BY a.col4;

????

[peterlaursen]

What you get depends on how you enter in the grid!  So if you posted a screenshot of your grid I would be able to tell if this is a bug or not!  You can generate both!

the two rules are:

1) what is entered in the same row of the grid is logically AND'ed and the rows are logically OR'ed

2) criteria going to the WHERE and HAVING clause are treated independently

[peterlaursen]

I also think that you study the program help file a little.

Especially the last example in the paragraph on the Query Builder.

With this type of grid we cannot support “A AND (B or C)” directly, it will need to be rewritten (using common boolean mathematics)

– like “A AND (B or C) = ( A AND B ) OR ( A AND C )“

Have a look on how you treat a condition that year(delievery) shall be AND'ed with country like 'India' OR 'Pakistan' etc in that last example of the program help file.

[morgande]

Ok, I got it working using the querybuilder now, thanks ..

[Author]

Posts