Re: 4gl case sensitive

In article <2mn4io$bvj@emory.mathcs.emory.edu> alan@po.den.mmc.com (Alan Popiel) writes: > >Informix does not support case insensitivity at the SQL level. > >Your 4GL program would have to take any input data and generate the {x}nameup >fields from the {x}name fields before storing the data. Similarly, your >program would convert any search criteria to upper case, search on the >{x}nameup fields, and then display the {x}name fields. If you use the {up,down}shift attributes on the key fields in the form definition, Informix will shift the case of any query input. Still kind of clunky, though. I also vote to add support for case insensitive searches to the engine. The "standards" be damned, we've got work to do. I'd want it to be easily useable within QBF, so the question of syntax and control arises. Perhaps that's what kept it out of the standard in the first place. Walt. -- Walt Hultgren Internet: walt@rmy.emory.edu (IP 128.140.8.1) Emory University UUCP: {...,gatech,rutgers,uunet}!emory!rmy!walt 954 Gatewood Road, NE BITNET: walt@EMORY Atlanta, GA 30329 USA Voice: +1 404 727 0648