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
Top
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.
Top
Post Reply

Return to “MySQL Data Access Components”