topic Re: case sensitve in Application Development and Automation Discussions

case sensitve

Former Member — Tue, 17 Oct 2006 15:49:26 GMT

Hi All,

I am retriveing the data from database tables.

there some records in uppercase and some records in lower case when i give value in selection screen in upper case it is retriveing the for only upper case but it has to ignore the case.

Please any one give me the solution for this.

Thanks in Advance.

Thanks&Regards.

Ramu.

Re: case sensitve

venkata_ramisetti — Tue, 17 Oct 2006 15:51:41 GMT

Hi,

Looks like you are using field that contains data element with type CHAR type and property in Domain Lower case = blank.

Use the parameter loike below type..

PARAMETER: P_TEXT TYPE TEXT100.

You can use builtin data elements Text100, Text 200, TEXT256..etc for texts .

Thanks,

Ramakrishna

Message was edited by: Ramakrishna Prasad Ramisetti

Re: case sensitve

Former Member — Tue, 17 Oct 2006 15:54:03 GMT

Hi Ramu,

In the Field check at the DOMAIN -> Definition level

whether the field is marked LOWER CASE.

If this flag is set, upper case and lower case are distinguished when you enter values with screen masks.

Otherwise all the letters entered will be converted to upper case when you enter values with a screen mask.

So while reading the table you:

case 1 - Translate to Upper case and read the table.

if this fails.

case 2 - Translate to lower case and read the table.

if both fails, then only throw the error message.

Reward Points if this helps.

Manish

Message was edited by: Manish Kumar

Re: case sensitve

Former Member — Tue, 17 Oct 2006 15:54:05 GMT

hi Ramu,

Declare the parameter of database field type ...

REgards,

Santosh

Re: case sensitve

Former Member — Tue, 17 Oct 2006 15:54:42 GMT

U can do is define a range for the particular field.

Populate the range with upper case value(enter via selection screen).

Translate the screen values to lower case.

Append the data to range.

If you use the range as the selection criteria, it would fetch both upper and lower case data.

Re: case sensitve

Former Member — Tue, 17 Oct 2006 16:22:09 GMT

Hi,

U may translate in lower case or vice-versa .

eg. TRANSLATE c TO LOWER CASE.

if helpful pl reward.

Cheers.

Re: case sensitve

Former Member — Tue, 17 Oct 2006 16:24:00 GMT

There are two solutions:

The first (and easiest) is to check to see if there is another similar field in the table that has the same data but in upper case. If there is one, use it.

If there is no such field, you can use native SQL to do this.

Rob