topic Re: Table maintenance in Application Development and Automation Discussions

Table maintenance

Former Member — Thu, 17 Sep 2009 03:38:58 GMT

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

Re: Table maintenance

Former Member — Thu, 17 Sep 2009 06:10:27 GMT

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

Re: Table maintenance

Former Member — Thu, 17 Sep 2009 08:58:25 GMT

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

Re: Table maintenance

Former Member — Thu, 17 Sep 2009 09:03:00 GMT

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

Re: Table maintenance

Former Member — Thu, 17 Sep 2009 11:21:09 GMT

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

Re: Table maintenance

Former Member — Mon, 27 Sep 2010 09:11:09 GMT

resolved