× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



<snip>
I suppose one approach might involve creating a temporary table to hold
the selections, then use DIV = any (select * from templist) or DIV in
(select * from templist) in the WHERE criteria (or inner join).
However, this won't work if no divisions are in the list (implying that
all divisions are valid). I can see potential workarounds (using
subselect IS NOT NULL) to short-circuit the where clause for this piece,
but all those subselects are ugly.....
</snip>

I think you are on the right track to use a Global Temporary Table to
build the list.

Get the count of records in the temporary. If all divisions, it would
zero.

Exec SQL Set aCount = Select Count(*) from QTEMP/GlobalTemp;

Then the Where

Where aCount = 0 Or
DIVISION Exists (Select DIVISION From QTEMP/GlobalTemp)

The other way to do it would be if all divisions selected, just build
the list with all divisions. Either way would work.

Make sure you use a Global Temporary Table. A lot faster.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.