We need more information to help.

Can you specify the field, screen, and X3 version so we can make some wildly inaccurate guesses. 

Also, it might just be me, but since a data type is not necessarily specific to a column, it would probably be better to create a new data type rather than changing an existing one that might affect multiple columns. 

Happy New Year!!!  

Hi,

Stephen is right about creating a new datatype instead of modifying an existing one.

In your case, your issue probably comes from the table "ATEXTRA".

It's in this table that AX3 datas are stored in the field "TEXTE".

If not already done, you need to update this field too and validate the table.

Regards,

Laurent

Thanks Stephen

Its Working Fine.

let me know which datatype I have to use which upto 4000 characters limit.

Regards

Gautam

Its charater data and have mixture of special charaters.

Regards

Gautam

Gautam, I have in the past used the ACPLAIN data type for this type of data.

Thanks Michael for reply

In Table Dictionary While I add new field error  messgae come.

Sage X3 Application Error

Text file length too long : 4995

Regards

.Gautam

Gautam, Use a length of 10. ACPLAIN length is measured in blocks of 512, so a length of 10 will handle 5120 characters.

True but the Issue is while I use ACPLAIN Datatype and even I enter length 1 or any length upto 10 it gives error Sage X3 Error -Textfile length is too long -4995.  Is there any another field in table  dictionary which I have to select.

Regards

I tried it by creating new table its working , I mean new table its taking length 10. but I  have to add it in ITMMASTER table.In ITMMASTER it  gives error Sage X3 Error -Textfile length is too long -4995. 

Is there any limitation.

Regards

Moreover problem is same , this field not reflecting in Selection Objects while using OBJECTS to create new selection window for new table  where I have added ACPLAIN field .

In selection window mean creating object can be add or sum two field values to show single record.

Regards

I have sage X3 V7 . I have a description 4000 characters long . I have added a field ACB datatype but while I create a selection window its not showing this field. Even I tried ACPLAIN its also not showing in selection window. 

If you have any solution , let me know.

Regards

Gautam

Gautam, 

It sounds like you might be running into a limitation of X3, or I might be misunderstanding you. It would be hard to tell without looking at what you're doing. I'd suggest logging a ticket with Sage or getting help from an experienced X3 partner.

Thanks Michael for your best feedback

.

Just a quick note. AX3 data type affects over 200 fields throughout X3.

You must create a new data type if you wish to increase specific field lengths.

Also be aware that some of the processes will still use 30 characters as in some instances it is hard coded.

As an example if you create a purchase request and then generate an order from it using the order button that has a hard coded value.

if you create the order manually it will accept the updated character string..

X3 is full of those little traps. That is why Sage themselves tell you to never update the field length for descriptions unless you have a developer to hand.