Hows it going everyone. Im having a little trouble with a memo field and a subquery in my Win32 App, Im using an Access DB. The query was working fine before, but in my access db, I had to change the Filename column from Text to Memo because the text type was limited to 255 characters. Now I am getting an error "Invalid Memo, OLE, or Hyperlink Object in 'Filename'." Im using this query to fill a datatable via TableAdapter.
Heres the query:
SELECT DISTINCT Filename AS Expr1
FROM Table1
WHERE (Filename NOT IN
(SELECT Filename AS Expr1
FROM Table2))
If someone could please help me get this corrected I would greatly appreciate it! Thanks
Heres the query:
SELECT DISTINCT Filename AS Expr1
FROM Table1
WHERE (Filename NOT IN
(SELECT Filename AS Expr1
FROM Table2))
If someone could please help me get this corrected I would greatly appreciate it! Thanks
Comment