Page 1 of 1

TMyQuery and SetWhere ????

Posted: Fri 11 Feb 2011 14:39
by 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 :D It's really appreciate!!! :)

Posted: Fri 11 Feb 2011 15:16
by BigJuice
We can mark this topic as Resolve :P

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

Posted: Mon 14 Feb 2011 14:15
by 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.