Case sensitivity in domain level

[Former Member]

Dear all ,

There is a z table with having some field and data .

That field is not case sensitive at Domain level

so we are able to put any data as the data type is char type ,

but when im giving the same data while making the selection it is showing

"NO DATA EXIXTS FOR THAT SELECTION"

For ex.: i have a field value in table say "Reliance Comm", it is there in the table but if u came out of it.

And give the same value "Reliance Comm" at the selection screen while making the enrty its saying

"No table entries found for the specified key"

but if im giving "RELIANCE COMM" it is showing me the valid result.

As i have to pass some value to this table at run time and also fetching some data from the table

based on selection screen in a report ,so its creating problem .

Please help <removed by moderator>.

Edited by: Thomas Zloch on Jun 11, 2010 5:32 PM

[Former Member]

HI,

Convert the values to uppercase b4 passing to select

[Former Member]

Hi Madhukar,

Thanks for the reply

could you please tell me how can i achieve the same?

[Former Member]

hi chandan,

in domain there is one lower case indicator...if it is set then uppercase and lower case are distinguished when you enter values with screen masks.Otherwise if you dont check it, all the letters entered will be converted to upper case when you enter values with a screen mask.

to convert to uppercase.....

DATA text TYPE string.

text = `Hello World`.

TRANSLATE text TO UPPER CASE.

hope this help you...

thanks and regards,

tanmaya

[Former Member]

Moderator message - Please do not ask or answer basic questions - thread locked Rob