Truncated Data From Sql View

I'm trying to query from a SQL view and am getting strange results in my application. If read the length of a field - DISPLAY LENGTH(contactName) I'll get a result that makes sense - like 24 characters. However, when I attempt to display the field itself, I get only the first character.

A Display statement yields an error - "FILL-IN contactName will not fit in frame in program". If I display a substring, export to a file, view the field as an alert-box, or any other way to see the data, all I see is the first character.

Does anyone have any suggestions on how I can troubleshoot and resolve this?

Much appreciated!

-Dan
 

Cringer

ProgressTalk.com Moderator
Staff member
What is the definition of contactName? Get the full details from a df.
 
Top