topic Re: problem in converting into upper case urgent in Application Development and Automation Discussions

problem in converting into upper case urgent

Former Member — Wed, 31 Jan 2007 06:24:35 GMT

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.

Re: problem in converting into upper case urgent

Former Member — Wed, 31 Jan 2007 06:28:40 GMT

HI rammohan..

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

TRANSLATE <screen field name> TO LOWER CASE.

Pls close the thread when problem is solved and reward to all helpful answers

Regards

SAB

Re: problem in converting into upper case urgent

Former Member — Wed, 31 Jan 2007 06:32:32 GMT

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.

there is field checkbox called UPPER/LOWER CASEat the bottom of the properties... if tick this u r porblem will be solved

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

Reward if Helpful

Regards

Naresh Reddy K

Message was edited by:

Naresh Reddy

Re: problem in converting into upper case urgent

Former Member — Wed, 31 Jan 2007 06:34:36 GMT

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

Re: problem in converting into upper case urgent

Former Member — Wed, 31 Jan 2007 07:00:09 GMT

Rammohan,

under PAI event.

In any module use below code.

TRANSLATE <screen field name> TO LOWER CASE.

Pls rewar if useful

Re: problem in converting into upper case urgent

Former Member — Thu, 01 Feb 2007 21:36:06 GMT

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

Re: problem in converting into upper case urgent

Clemenss — Thu, 01 Feb 2007 22:35:02 GMT

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

Re: problem in converting into upper case urgent

Former Member — Fri, 02 Feb 2007 04:42:54 GMT

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