Re: Three cheers for 4gl's CONSTRUCT

>The CONSTRUCT statement in 4gl is the best thing ever. >Only when you try to re-create a similar functionality in >another database do you realize how great it is. >Once users have been given this powerful tool, it is >almost impossible to get them to accept a data screen >that does not include it. >As you may have guessed, I am currently faced with providing >Query-By-Example (Query-By-Form) functionality in a system >written in something other than 4gl. I just wanted to spend >a little bandwidth to congratulate Informix on a job well done. We like the CONSTRUCT statement too. I just wish there was a way to specify that the query be case insensitive for char variables. Right now, we just upshift all char fields because the construct statement builds a where clause that is case sensitive. How about: OPTIONS CONSTRUCT CASE INSENSITIVE Mike Teachworth CodeGen Software, Inc 800-598-8649 504-456-1260 fax work email: mike@codegen.com