TMyTable filtert problem with IN (..., ...)

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Thomas J.
Posts: 95
Joined: Mon 21 Nov 2005 12:16
Location: Germany

TMyTable filtert problem with IN (..., ...)

Post by Thomas J. » Mon 21 Nov 2005 12:20

Hello,
I have a problem with the filter expresion of TMyTable. I want to define a filter like n_column_id IN (1, 2, 9) but I get a Errormsg "Illegal Filter expression".

Any ideas?

Thanks for your support

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Tue 22 Nov 2005 09:17

Filter property is applied on client side and doesn't support IN statement. If you want to use this statement you should use FilterSQL property.

Post Reply