Re: 4gl case sensitive (fwd)
netters, beware of a minor bug in the upshift function under INFORMIX-4GL Version 4.11.UC1. test program: database system main define c,u,d char(1) let c = '_' let u = upshift(c) let d = downshift(c) display "original character (",c,"), upshifted (",u,"), downshifted (",d,")" end main outputs: original character (_), upshifted (?), downshifted (_) ^^^^^^^^^^^ > X-Informix-List-Id: <news.5990> > > 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 > -- regards, +----------------------------------------------------------------------------+ | . . | | | ... ... | Bob Baskett | | ..... ..... | Software Engineer, DBA | | .. ... .. | Business Systems Integration Group | | . . . | Semiconductor Products Sector | | | Mesa, AZ | | Motorola, Inc. | | |----------------------------------------------------------------------------| | 'connectionLESS IS MORE' -- Data Broker | |----------------------------------------------------------------------------| | Duct tape is like the force. It has a light side, and a dark side, and | | it holds the universe together ... | | -- Carl Zwanzig | +----------------------------------------------------------------------------+