Null parameter error

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
jynghyun
Posts: 4
Joined: Mon 24 Sep 2018 01:11

Null parameter error

Post by jynghyun » Sat 15 Dec 2018 19:39

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'

jynghyun
Posts: 4
Joined: Mon 24 Sep 2018 01:11

Re: Null parameter error

Post by jynghyun » Sat 15 Dec 2018 20:11

Solved.

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

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Null parameter error

Post by ViktorV » Mon 17 Dec 2018 11:32

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.

Post Reply