topic Re: SELECT-OPTION in Application Development and Automation Discussions

SELECT-OPTION

Former Member — Mon, 20 Nov 2006 15:57:36 GMT

Hi all,

selection-screen begin of block

select-option name user02-NAME.

END OF SELECTION-SCREEN

I WANT VALIDATE NAME FIELD

in the database name field contains both uppercase and lower caserecords

support user enter lower case record in the name field

but in the database it has upcase record

how to validate the case sensitive for name feld in the selection screen

Plz send the reply or sample code for this

i look forward to your reply

Thanks & Regards

SEK

Re: SELECT-OPTION

Former Member — Mon, 20 Nov 2006 16:01:00 GMT

Hi,

Just declare Select opton like this,

select-options name for user02-name LOWERCASE.

Then it will be case sensitive, it will take both upper and lower case letters

Sreedhar

Re: SELECT-OPTION

Former Member — Mon, 20 Nov 2006 16:01:31 GMT

if u use select-option name user02-NAME no need to specify, but when user enters name and press execute it gets converted to upper case automatically....so, the data ur fetching from database, modify this data to uppercase and then compare with the selection-screen option...

Re: SELECT-OPTION

suresh_datti — Mon, 20 Nov 2006 16:02:19 GMT

Use the TRANSLATE TO UPPER CASE & then compare..

~Suresh

Re: SELECT-OPTION

Former Member — Mon, 20 Nov 2006 16:03:07 GMT

hi,

Give this way ..

<b>

select-option name user02-NAME UPPERCASE.

</b>

Regards,

Santosh

Re: SELECT-OPTION

RichHeilman — Mon, 20 Nov 2006 16:03:27 GMT

Translate the values in the Select-option to uppercase. Then validate.

Loop at name.
  translate name-low to upper case.
  translate name-high to upper case.
  modify name.
endloop.

Regards,

Rich Heilman

Re: SELECT-OPTION

Former Member — Mon, 20 Nov 2006 16:08:01 GMT

Hi Raja,

You can use TRANSALTE TO UPPER CASE/LOWER CASE to change a string from upper to lower case and vice versa. Are you going to do a select using the name that user enters or is it just a user id?

checkout the domain of user02-name, there should be a check box lower case. IF this is checked then data in DB will be as we enter it (both lower case or upper case). If it is not checked then its always stored in upper case -- this case is easy since you can translate what ever user enters to UPPER CASE and do a select on DB. But if the data can be either in lower/upper or both then you might have to do little bit more work.

Hope this information helps.

Cheers

Re: SELECT-OPTION

Former Member — Mon, 20 Nov 2006 16:11:22 GMT

Hi,

convert the string entered into upper case using

s_name2 = s_name1.

translate s_name2 into uppercase.

Now write ur select this way

select X Y Z from user02 where name in s_name1 or s_name2.

hope this gives u an idea.

regards,

keerthi

Re: SELECT-OPTION

Former Member — Mon, 20 Nov 2006 16:14:03 GMT

Validate it against view USER_ADDR, field MC_NAMELAS. This is how SAP does it in search helps.

Rob