Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
- Posts: 164
- Joined: Tue 24 Nov 2009 19:33
FilterSQL does not seem to work.. I have tried refreshing the dataset, without refreshing, with close + open, set filtered to true, leaving filtered unchanged..
I have a query similar to
and I need to add a filter
Code: Select all
where Element not in (select Element from Combination where Id is = 8)
"8" being just an example.. the Combination table having Id and Element fields.
- Devart Team
- Posts: 1001
- Joined: Fri 11 Apr 2014 11:47
- Location: Alpha Centauri A
Check whether the condition from the TMSQuery.FilterSQL value is added to the WHERE clause of the executed query. You can see the really executed SQL query using DBMonitor.
If the TMSQuery.FilterSQL value is not added to the WHERE clause, send us a small test sample of using FilterSQL.