Devart Forums

Using unidac + mysql provider

select * from income where id = ifnull(:aid, id)

If I pass 'aid' parameter value as null value, I get following error. Can you help me?
If aid is not null, it works well.

ErrorCode: -2147467259, Number: 1054
ErrorMessage: Unknown column 'aid' in 'where clause'

Solved.

I thought I built it with unidac but not. it is using .net COM dll.

It is good to see that the problem has been solved.
Feel free to contact us if you have any further questions about our products.