×
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.
I have a "search string" field to scan over multiple fields...
currently we are doing this with RPG example:
if s1xcnt = *blanks or
%scan(%trim(s1xcnt):%xlate(lw:up:mnujob)) > 0 or
%scan(%trim(s1xcnt):%xlate(lw:up:mnuonm)) > 0) ;
I am attempting to do this in a where clause, but not getting it right
where UPPER(mnujob) like('%.......%) or
UPPER(mnuonm) like(%......%)
I have tried doing various %trim commands,
I have tried doing this as both a Prepared SQL statement, and inline...
I tried doing this with OmniFind, but that was overly complex with building
multiple index objects...
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.
midrange.com
