topic Re: String retrival in Application Development and Automation Discussions

String retrival

Former Member — Mon, 03 Mar 2008 14:52:02 GMT

Hi all,

How to retrieve string value which is given in a parameter as such. That is, if i give a string like 'Wett', it is being changed to 'WETT'. But i want it to be 'Wett' only. How to do that?

Regards,

Harish.

Re: String retrival

Former Member — Mon, 03 Mar 2008 14:55:01 GMT

in table declaration, there is a small checkbox, which allows small characters in table fields.

check it.

OMG lol not table declaration i´m a moron, rather go fpr the post below mine

Edited by: Florian Kemmer on Mar 3, 2008 3:58 PM

Re: String retrival

Former Member — Mon, 03 Mar 2008 14:56:59 GMT

hi ,

use this ,

parameters:p_like(10) type c lower case.

write:/ p_like .

Re: String retrival

Former Member — Mon, 03 Mar 2008 14:58:28 GMT

Hi Harish,

This can be done using domain defination. Just go to SE11 and domain of the data element you are using and check the check box which allows lower case.

Regards,

Atish

Re: String retrival

Former Member — Mon, 03 Mar 2008 15:59:37 GMT


This can be done using domain defination. Just go to SE11 and domain of the data element you are using and check the check box which allows lower case.

Man! You don't want to do that on a Standard Data Element, don't you?

It's better to use LOWER CASE extension...Or maybe...


TRANSLATE P_PARAM TO LOWERCASE.

Greetings,

Blag.

Re: String retrival

Former Member — Mon, 03 Mar 2008 17:34:49 GMT

You can use native SQL so that the case doesn't matter either on the selection screen or the database.

Rob

Re: String retrival

Former Member — Tue, 04 Mar 2008 05:19:34 GMT

Hi,

I tried with the native SQL. But it didn't work. Actually my requirement is, i need to check the select option value with the table ( STD table) field. I need to retrieve the records whose name (field name is NAME1) equals to 'Wett'. In table, it is stored as 'Wett' only( First letter alone is in CAPS, others are in SMALL), But inside my coding, the select option value is changed WETT (All CAPS), so it doesnt retrieve the records whose name is 'Wett'. How to resolve this?.

Could anyone tell me clear idea..

Regards,

Harish.

Edited by: Harish Kumar on Mar 4, 2008 12:00 PM

Re: String retrival

Former Member — Tue, 04 Mar 2008 14:00:06 GMT

Then declare the parameter LIKE the filed you are SELECTing.

Rob

Re: String retrival

Former Member — Tue, 04 Mar 2008 14:13:12 GMT

hi check this ,


parameters:p_test(10) type c lower case.

write:/ p_test.

parameters:p_test1(10) type c .

write:/ p_test1.

pass the name with the lower case then you got the result,

<REMOVED BY MODERATOR>

venkat.

Edited by: Alvaro Tejada Galindo on Mar 4, 2008 12:07 PM