Re: oracle forms 5.0 queries!

From: Marc Billiet <Marc.Billiet_at_hae.hydro.com>
Date: Tue, 22 Dec 1998 07:22:19 +0100
Message-ID: <75ndo3$7u0$1@vkhdsu24.hda.hydro.com>

Forms 5 has an item property called Case Insensitive Query. Did you try that ?

Marc

janakah_at_my-dejanews.com wrote in message <75kd56$55q$1_at_nnrp1.dejanews.com>...
>Hi,
>
>Stated below is my problem. I got a database table with a varchar2 field.
>Data enterd in this field is smoetimes in uppercase and sometimes in lower
>case. So when the users tries to fetch data through forms 5.0, if they
enter
>the search criteria in lower case and the data is in upper case they cannot
>retrieve it. I don't want to set the "case restriction" property as the
user
>wants the option of entering data either in uppercase or lowercase. Is
there
>a way of converting data to either uppercase or lowercase at query time.
>
>TIA
>
>Janaka
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Dec 22 1998 - 00:22:19 CST