Devart Forums

Hello

What is the difference between filter and filtersql properties on TuniTable ?
Filter does not seems to work.
Is it possible to automatically call FilterSQL when Filter is called ?

Thanks

Hello,

If the condition is set in the Filter property (and the Filtered property is set to True), data is filtered locally; if the condition is set in FilterSQL - this condition is added to the WHERE clause of the query, and the query with the condition is executed on the server.

Interesting, but I am porting some apps and I have noticed that I can't make the filter property work either, only the FilterSQL.

Wierd, to say the least.

Please describe in more details the problems you have faced with when using the Filter property - and we will try to help you solve them.

AlexP wrote:Please describe in more details the problems you have faced with when using the Filter property - and we will try to help you solve them.

For example when I moved from dbx to UniDAC I changed to FilterSQL because Filter does not support Lower(). TClientDataSet does. It was a little hassle but was faster to implement than other options.
Maybe there is something similar with @andrewsvaz.

Best Regards,
Cristian Peta

We have added a possibility to use Lower and Upper methods in the Filter property. This feature will be included to the next version.

AlexP wrote:We have added a possibility to use Lower and Upper methods in the Filter property. This feature will be included to the next version.

Thank You.

You are welcome. Feel free to contact us if you have any further questions.