Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Table maintenance

Former Member
0 Kudos
218

Hi,

We have created a maintenance view for a table which basically stores URL information.

If we maintain any URL using SM30,the entries are getting saved in upper case,is there a way to restrict it.

Please clarify.

Thanks & Regards,

Keerthi

1 ACCEPTED SOLUTION

Former Member
0 Kudos
185

Hi,

In PAI you can translate it to lower case


PAI

CHAIN.
 field URL1 module conevrt_to_lowercase.
ENDCHAIN.


module convert_to_lowercase inout.
 if not URL1 is initial.
  translate URL1 to lower case.
endif.
endmodule.

Regards,

Himanshu

5 REPLIES 5

former_member624107
Contributor
0 Kudos
185

Hi Keerti,

I dont think that we can restrict it.

Better you can use function module 'EDITOR_LINE_TRANSLATE_CASE' to change the case.

Regards,

Sheeba

Former Member
0 Kudos
185

Hi Keerthi,

There is a solution but this will require a lot of rework.

The dataelement that will be used to store the URL, does it take the properties from a domain ?

if so in the domain properties, there is something called 'Lower Case'. Check that.

If you are not using it. Please create a domain check the 'Lower Case', create a data element

using that domain. Use this data element in your table.

Now whatever u enter in ur maintenance will be stored as it is without the case being changed.

Regards,

Pramod

Former Member
0 Kudos
186

Hi,

In PAI you can translate it to lower case


PAI

CHAIN.
 field URL1 module conevrt_to_lowercase.
ENDCHAIN.


module convert_to_lowercase inout.
 if not URL1 is initial.
  translate URL1 to lower case.
endif.
endmodule.

Regards,

Himanshu

Former Member
0 Kudos
185

Hi,

I assume if changing all those parameters will be a burden for you, you can write code to update the table.

This is not the right way, but this certainly is a workaround.

Regards,

Pramod

Former Member
0 Kudos
185

resolved