Solved: UNION and FilterSQL

[waheed]

I have an sql statement with a union. But when I added a FilterSQL to the TMyQuery the result was not filtered, only the last select was filtered the first was not.
Any thoughts?

I have found a solution: Put the whole union in a select like this:

Code: Select all

Select * from 
( select * from table1
union 
select * from table2) as resulttable

Now when I do a filter it is applied to the result as a whole.

Thanks

[ViktorV]

You have found a correct solution for the problem, since the value of the TMyQuery.FilterSQL property is added to the last WHERE clause of your SQL query.