Re: CONSTRUCT help needed

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 > > Thanks, > Michael Hoffman Not easily. If you had two entries into your construct routine (we use "Query" and "Locate") the second option could be used for appending new construct where-clauses to the end of the where-string generated in the first ("Query") construct. So, it takes multiple queries to narrow down the select when "<>" is used in a field. -- ______________________________________________________________________ | Colin McGrath cmm@trac3000.ueci.com | | Raytheon Engineers & Constructors, Inc. (215) 422-4144 | | Phila, PA, USA | | Any opinions I state are my own and not necessarily of my employer | |____________________________________________________________________|