Re: CONSTRUCT help needed

Posted in 1998

Jonathan Leffler — Sat, 07 Nov 1998 10:33:34 -0800 — source: Informix-list mailing list archive (1991-1998)

Michael Hoffman wrote: > A user has posed an interesting question: > > In a CONSTRUCT screen, how can you exclude multiple values of a > single field? A single exclude (<> or !) is easy. Choosing > multiples (|) converts the SQL to an "in" clause. > > Now, how do you combine the two? We have tried every permution > of these that we can think of. Nothing works.... > > Platform: HP9000 running HP-UX > Version: Informix v. 7.1 There isn't a way to do it. The parsing of CONSTRUCT queries is not as comprehensive as you'd like. Another common request is: *ABC*|*DEF* That gets translated into a single MATCHES clause, not into two alternative MATCHES clauses. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>