I have a field with data type of memo in my access database. I run a
query from c# to access this field and it cuts off my string to only
255 characters. If i run this query directly in access it works fine.
If i run this query without the iif statement it works fine. It only
cuts off my string when i run this query in c# WITH the iif statement.
Here is the statement that doesn't work.
SELECT
IIF(ISNULL(t1.field1), t2.field1, t1.field1) AS desc
FROM
table1 t1 LEFT JOIN t2 ON t1.field2 = t2.field2
If you run this in access it works. If you change it to:
SELECT
t1.field1
FROM
table1 t1
it works fine.
It just doesn't work in c#. Can anyone help