Clause OR inside of the where

rbuser

? Inside of Designer I need to place the clause " or " inside of my
where. As I place that " or " visually
in the report Builder without publishing SQL manually, for not losing
the visual resources?
Thanks

Cela

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

nicocizik

Hi Cela,

Below is my response to a similar question a couple days ago. I see you
found this thread as well.

--

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