Active Query Builder  »  User's Guide  »  Building a single query

User's Guide

Defining criteria

Index  Previous  Up  Next

To define the criteria, you can use the Criteria and all of the Or columns of the Columns Pane.

In these cells, you should write the conditions omitting the expression itself. For example, to get the following criteria in your query:

WHERE  (Field1 >= 10) AND (Field1 <= 20)

you should type ">= 10 AND <= 20" in Criteria cell of a Field1 expression.

Criteria placed in the Or columns will be grouped by columns using the AND operator and then concatenated in the WHERE (or HAVING) clause using the OR operator. For example, this visual representation will produce the following SQL statement. Please note that the criteria for Field1 are placed both to the Criteria and Or columns.

WHERE (Field1= 10) AND ((Field2 < 0) OR (Field2 > 10))

Some expressions may be of the Boolean type, for example the EXISTS clause. In this case you should type "= True" in the Criteria column of such expressions or "= False" if you want to place NOT operator before the expression.

BTW, the most common practice to learn for how to build some query is to write it once by hand and see how it will be parsed and represented visually.

Index  Previous  Up  Next

News

Tweets

Testimonials

We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!

We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...

In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!


Social networks