TUniTable difference between Filter and FilterSQL

[testpresta]

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

[AlexP]

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.

[andrewsvaz]

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.

[AlexP]

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.

[CristianP]

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

[AlexP]

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

[CristianP]

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.

[AlexP]

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