1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Truncated Data From Sql View

Discussion in 'DataServers and ODBC' started by Dan Packer, Aug 28, 2017.

  1. Dan Packer

    Dan Packer New Member

    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!

  3. Cringer

    Cringer ProgressTalk.com Moderator Staff Member

    What is the definition of contactName? Get the full details from a df.

Share This Page