Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 208
  • Last Modified:

Memo field returning Null values

I have an SQL query that pulls data from an ODBC connection to a system DSN I have set up.  Everything works fine until I try to add one more field.  The field is listed in the database schema as a 'text' field with a limit of 8001 char... so I am assuming it is like a Memo field in Access.  When I add that field, all the fields are returned as Null.  I know there is data in that field because I can query it in Crystal and get data, but when I use that same query in VB it comes back Null.  Help!
0
jmoran18251
Asked:
jmoran18251
  • 2
  • 2
1 Solution
 
jmoran18251Author Commented:
500 points and a six pack?  I'm dyin' here...
0
 
jmoran18251Author Commented:
500 points and a twelve pack?!?!?!?
0
 
rejoinderCommented:
Have you tried to run the same select or query statement from SQL Query Anayzer?  It should return the same results as did Crystal.  If not, then we need to look at the select statement or the DNS connection you are using.
0
 
Anthony PerkinsCommented:
Please post your code and database version.
0
 
Anthony PerkinsCommented:
Also post the structure of your table.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now