× 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.



If FILEA contains FIELD1 and FIELD2 and I want to give user an option to 
selection records by FIELD1 that is >, >=, =, <, or <= the value he/she entered 
on the screen, what would be the best way to do this using Case in where 
clause?  Let say host variable field1Filter contains the option that user 
selected.
 
I wish I can do below, but it is not a valid SQL statement.
 
Select * from FILEA
    where case field1Filter 
        when '>' then
             FIELD1 > :screenField1
        when '>=' then
            FIELD1 >= :screenField1
         .....
        endcase
 
Any suggestion?
 
 
Note: Do not wish to use dynamic prepare sql statement.
 
thanks
 

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.