×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Display Comment field with A4000 datatype

Display Comment field with A4000 datatype

Display Comment field with A4000 datatype

(OP)
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,

RE: Display Comment field with A4000 datatype

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.

RE: Display Comment field with A4000 datatype

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

RE: Display Comment field with A4000 datatype

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

RE: Display Comment field with A4000 datatype

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 .

RE: Display Comment field with A4000 datatype

(OP)
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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close