Memo field returning Null values
Posted on 2009-04-02
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!