Re: Casesensitive

In article <2621_at_nikhefh.nikhef.nl> b09_at_nikhef.nl (Jeroen Hermans) writes:

> I have a problem in SQLForms2.3. When I want to search for data making
> use of ENTQRY I want to find all data ignoring if the query uses upper
> Case or lower-Case or a combination. I can not ask the user to use UPPER
> or LOWER. I think that this problem is solved by other users. Can anybody
> give me a hint how I can do this with triggers or something. Oracle is
> running on a SUN.

1. replace the database field with a non-database field
2. put the database field on page 0
3. in the where clause, put something like

    UPPER(ENAME) = NVL(UPPER(:ENAME_DSP),ENAME) 4) in the post query trigger, copy the value of :ENAME into :ENAME_DSP 5) code your post-change/pre-commit trigger accordingly.

--
 Alvin W. Law .............................................. Oracle Corporation
 Senior Applications Engineer .................. 300 Oracle Parkway, Box 659306
 Manufacturing Applications .......................... Redwood Shores, CA 94065
 Email: alaw_at_oracle.com ........... Voice: 1.415.506.3390 . Fax: 1.415.506.7299