Table maintenance

[Former Member]

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

[Former Member]

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]

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]

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]

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]

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]

resolved