TMyQuery and SetWhere ????

[BigJuice]

Hi Everybody,

Here is my question... I just discovered that a function "SetOrderBy" exists and I want to know if is there another function to set a Where clause ?

Thank you to everyone who will help me It's really appreciate!!!

[BigJuice]

We can mark this topic as Resolve

I found in the help what is the property that I need to use
The property is "FilterSQL"

[AndreyZ]

Hello,

You can use the AddWhere method that adds condition to the WHERE clause of SELECT statement in the SQL property. For more information please read the MyDAC documentation.