On Thu, 21 Oct 2004 15:12:37 +1300, Robert martin <rob@...> wrote:

> Hi
>
> Wouldn't the whole thing be easier to maintain if it was two SQL
> statements, one
> that is used for All results and the other that is a subset of the
> results?

Yes, but the real situation is slightly different. James has a SQL
statement like this one:

SELECT *
FROM ATable T
WHERE (1=:ACTIVEFILTER_NAME OR T.ANAME LIKE :CUST_NAME) AND
(1=:ACTIVEFILTER_CITY OR T.CITY LIKE :CUST_CITY) AND
.....

in User Interface James has several check-boxes with edits and user can
filter data by different combination of fields and values. I am right
James?

So - you cannot supply different SELECT statements for every combination
of selected fields to filter.

Cheers,
--
Miroslav Penchev