Solved

Memo field returning Null values

Posted on 2009-04-02
5
201 Views
Last Modified: 2013-12-25
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
Comment
Question by:jmoran18251
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 

Author Comment

by:jmoran18251
ID: 24051163
500 points and a six pack?  I'm dyin' here...
0
 

Author Comment

by:jmoran18251
ID: 24051882
500 points and a twelve pack?!?!?!?
0
 
LVL 14

Accepted Solution

by:
rejoinder earned 500 total points
ID: 24056728
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
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24067871
Please post your code and database version.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24067875
Also post the structure of your table.
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses
Course of the Month6 days, 2 hours left to enroll

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question