About Query Designer

rbuser

Hi,
I'm using Delphi 6 Professional and ReportBuilder Enterprise Editino 10.03.

I need build a report based on a query with a WHERE clause containig AND and
OR (for ex. .... WHERE (Condition1 AND Condition2) OR (Condition3 AND
Condition4) .... ).
How I create it in the Query Designer using search criterias and avoiding to
edit manually SQL (because I need also to create some links) ?
Thanks in advance

Davide

nicocizik

Hi Davide,

If you right click over the fields added to the Search tab in the query
designer, you will see that you can insert parentheses and OR statements.
Using these controls and the "move up" and "move down" arrows on the right,
you can set up a search criteria that looks something like the following...

begin
Field1... search condition
Field2... search condition
end
OR
begin
Field1... search condition
Field2... search condition
end

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Hello Nico,this doubt also was mine.Thank's

Cela

--- posted by geoForum on http://delphi.newswhat.com