topic Re: STRING type fields, any risk? in Application Development and Automation Discussions

STRING type fields, any risk?

former_member194142 — Tue, 26 Nov 2013 19:46:27 GMT

Hello

In our system we have a Z table to store a Z module pool prog., wherein some field's data will is not fixed in lenght, for example, long texts entered by user on Z dialog prog.'s screen, like that we have 5 long text fields on this Z dialog prog., hence initial developer created a 5 fields with STRING data element in this Z table

Pls. let me know

1) is it OK to have 5 fields with STRING type data in the Z table?

2) At this point (users are using already in production since 3 months) can i remediate/repair it any thing?

3) If i leave it as is, going further, do we gonna have any risks/dangers?

Thank you

Re: STRING type fields, any risk?

balbino_soaresferreirafil — Tue, 26 Nov 2013 20:38:04 GMT

I can't see any risk, but i think the better way to do this was creating long text through SO10 transaction. And populating this long text in your z program....

Remember with the string field has a lenght of 255 characteres.... Thats the only problem i can see...

To change this, will be necessary create a routine to migrate the data from string field to long text, or do this manually.

If you need more help about use long text let me know...

Regards

Re: STRING type fields, any risk?

former_member194142 — Tue, 26 Nov 2013 21:57:35 GMT

Thank you.

Its not prog. is defaulting on the screen, user enters text any # of length, then the Z prog. is storing it in Z table, hence SO10 ruled out

I guess, the STRINGVAL is not of 255 lenght, its like infinitive

As SO10 ruled out hence not migrating

Re: STRING type fields, any risk?

Former Member — Wed, 27 Nov 2013 02:40:25 GMT

Yes, There is no problem in using string type variable.

And yes string is not limited to 255 character. When user want to see data in string by debugging a code it will show you 255 char but it can store more then that.

Re: STRING type fields, any risk?

former_member194142 — Wed, 27 Nov 2013 22:01:55 GMT

Let me keep open my question until maintenence window is done / Dec 02nd then i will close

THANK YOU