jmoran18251
asked on
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!
ASKER
500 points and a twelve pack?!?!?!?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Please post your code and database version.
Also post the structure of your table.
ASKER