problem in converting into upper case urgent

[Former Member]

hi,

i working on module pool program.

in the initial screen there is two fields one is number one is name.

if i enter the name in the name field it is automatically converting into upper case,

but in this case my select query is not working,how to solve this,i mean i have to take same as it is what i entered.

kindly give me suggestion.it is urgent issue.i have to delever today.

Thanks,

mohan.

[Former Member]

hi,

i working on module pool program.

in the initial screen there is two fields one is number one is name.

if i enter the name in the name field it is automatically converting into upper case,

but in this case my select query is not working,how to solve this,i mean i have to take same as it is what i entered.

kindly give me suggestion.it is urgent issue.i have to delever today.

Thanks,

mohan.

[Former Member]

HI rammohan..

why dont u convert it into lower case before passing to select query using TRANSLATE command.

<b>TRANSLATE <screen field name> TO LOWER CASE.</b>

<i>

<b>Pls close the thread when problem is solved and reward to all helpful answers</b></i>

Regards

SAB

[Former Member]

hi

in the Report to handle like this situation.. we use the extentions to the parameter as LOWER CASE .

parameters p_t type char10 LOWER CASE .

i think in the Module pool also.. we can do this in Properties of the FIELD... once check the Properties of the field... there could be a chance.

hi

<b>there is field <b>checkbox called UPPER/LOWER CASE</b>at the bottom of the properties... if tick this u r porblem will be solved</b>

Please Close this thread.. when u r problem is solved

Reward if Helpful

Regards

Naresh Reddy K

Message was edited by:

Naresh Reddy

[Former Member]

in the attributes button of that field enable loweracase / upper inthe bottom portion in the attributes column.

double click on that field in screen layout and see the navigation

this will be at the screen painter attributes >attributes>dictionary subscreen-->check box with upper/lower case.

tick this check box .

regards,

vijay

[Former Member]

Rammohan,

under PAI event.

In any module use below code.

TRANSLATE <screen field name> TO LOWER CASE.

Pls rewar if useful

[Former Member]

Hi,

Another solution..

If you are referring the screen field to database structure-field...

Then check in the domain for the field if the Lowercase check box is set..

Otherwise set that checkbox..Then it allow both upper and lower case.

Thanks,

Naren

[Clemenss]

Hi RAMMOHAN,

if the name field is defined with the same type as the field in the where condition, then you have a field with upper and lower case characters an no conversion takes place.

tables:
  but000.
select-options:
  s_name1 for but000-name1.
select ... from but000 into ... where name1 in s_name1.
...

is no such good idea because name1 is not a key field but it shows you the direction - I hope.

Regards,

Clemens

[Former Member]

Hi,

u have two optiones.

If u refreing Ztable in the layout , check lowercase/upper case in the domain of the filed

or simply check lowercase/upper case in the attributes of the screen field

Regards

nagaraju