Display Comment field with A4000 datatype

[H1004]

I can't display this field because it gave me an error of:

Error msg:

THE MAXIMUM SPACE FOR COLUMN TITLES HAS BEEN EXCEEDED.
Each displayed data field may have from 1 to 5 lines as a column title. The total area for titles is 1210 characters, which includes the space needed for the line of dashes..The limit for one-line titles is 605 character.


Is there a work around this problem so that I can display this field??
Thank you,

 

[jimster06]

FOCUS is saying that the column heading size is excessive.
Try
TABLE FILE MYFILE
PRINT MY_BIG_FIELD AS 'MY,BIG,FIELD'
WHERE RECORDLIMIT IS 1
END
This should print your A4000 field with a three-line title;
the recordlimit statement is often used for testing, it cuts down the time.
If this doesn't work for your, please post your code.

 

[H1004]

Still getting that error message
Here is my code
TABLE FILE MESSAGE
PRINT
FROM_SENDER
MESSAGE_TEXT
WHERE RECORDLIMIT EQ 1
END
-EXIT

 

[jimster06]

1. What is the error number?
2. Could you post the MFD?

 

[Siddhamalli]

You can print memo type fields in webfocus you are allowed to use it only in header or footer , one thing you can to is convert manually the type to tx50 in the master file and then you will get the content .

 

[H1004]

Well it turns out that if you have version 5.23, then it is okay..But if you have version 4.36 & using Desktop then you need to change your edaprof file in your C drive by adding the following line
SQL SQLMSS SET CONVERSION LONGCHAR TEXT
and then change your datatype to tx50 in your master file.

I'm not sure how to change in the server side yet.