CONSTRUCT help needed

Posted in 1998

Michael Hoffman — 6 Nov 1998 15:07:54 GMT — source: Informix-list mailing list archive (1991-1998)

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 Thanks, Michael Hoffman