topic Re: Table with long text field in Application Development and Automation Discussions

Table with long text field

Former Member — Fri, 29 Jan 2010 11:30:27 GMT

Hi SDN,

I want to create table with table maitainance generator.

so i created transperant table.but i want to maintain a field with 1024 char long.

During checking it showing error "field is too long than 255"

How can i resolve it?

Re: Table with long text field

Former Member — Fri, 29 Jan 2010 11:46:21 GMT

Which data element is provided?

Re: Table with long text field

Former Member — Fri, 29 Jan 2010 11:53:46 GMT

Use data element DSVASDLONGDESCRIPTION and before declaring it include a length field of type INT4 in the table. It must be located directly before the long field in the field list.

Please also note that long fields must be located at the very end of the field list.

Re: Table with long text field

Former Member — Fri, 29 Jan 2010 11:57:02 GMT

Use data element of data type LCHR or LRAW.

Include a length field of type INT4 in the table. It must be located directly before the long field in the field list.

Please also note that long fields must be located at the very end of the field list.

Re: Table with long text field

Former Member — Wed, 03 Feb 2010 12:32:36 GMT

Try using data element CHAR1250 for the field in the table .

OR,

IN SE11 create a domain or char type and length u need.

Now assign this domain to the data element .