topic Re: case sensetive in Application Development and Automation Discussions

case sensetive

Former Member — Thu, 26 Oct 2006 11:05:50 GMT

Hi All,

I am retrieving the data from database tables (data element with type CHAR and property in Domain is Lower case). There some records in uppercase, some records in lower case and some records in both upper and lower case (test-DEMO-test). When i give value in selection screen in lower case it is retrieving for only upper case, the other cases are ignoring.

Is there any method to populate the selection screen values without changing the case.

Thanks in advance

Rajeev.

Re: case sensetive

Former Member — Thu, 26 Oct 2006 11:08:25 GMT

use the keyword "lowercase". then it works

go for parameter otherwise

regards,

Sandeep Josyula

*Mark helpful answers

Re: case sensetive

Former Member — Thu, 26 Oct 2006 11:08:53 GMT

Hi Rajeev,

While declaring selection screen, use Case sensitive statement for that field. It solves ur problem.

regards,

Chandra

Re: case sensetive

Former Member — Thu, 26 Oct 2006 11:08:58 GMT

Hi Muthu,

In selection screen

give the lower-case addition.

parameters: p_matnr(10) lower-case.

Regards,

ravi

Re: case sensetive

Former Member — Thu, 26 Oct 2006 11:12:13 GMT

Hi Chandra,

Some of the records are in upper case ...

Re: case sensetive

Former Member — Thu, 26 Oct 2006 11:22:49 GMT

Hi Sandeep,

The requirement was to retrieve the data, which is similar to “demo-IND-contract” and am using the select-options.

If I use lower or upper case, the select statement is not retrieving the above one

If I give demo it works

If I give IND it works

If I give demo-IND its not working.

Kindly suggest.

Thanks,

Rajeev.

Re: case sensetive

jayanthi_jayaraman — Thu, 26 Oct 2006 11:35:49 GMT

Hi,

parameters p(10) lower case.

write p.

Input:demoIND

Output:demoIND

lower case addition to parameters will take care of the data as it is inputted[case sensitive].

Re: case sensetive

Former Member — Thu, 26 Oct 2006 13:35:42 GMT

There are different techniques depending on the table. So could you tell us which table?

Rob