GET WHERE clause

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
cybsistemas
Posts: 118
Joined: Mon 12 Sep 2005 17:31
Location: Argentina

GET WHERE clause

Post by cybsistemas » Fri 24 Feb 2017 01:40

Hello
How do I find out the WHERE clause of a query?
Thanks

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: GET WHERE clause

Post by ViktorV » Fri 24 Feb 2017 09:33

You can use the following code to get WHERE clause:

Code: Select all

var
  WhereStr: string;
...
  WhereStr := _GetWhere(MyQuery1.SQL.Text, TMyParser, False, '');
You should add MyParser and CRParser units to 'uses' to compile this code.

cybsistemas
Posts: 118
Joined: Mon 12 Sep 2005 17:31
Location: Argentina

Re: GET WHERE clause

Post by cybsistemas » Sat 25 Feb 2017 04:08

Thank you very much ViktorV

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: GET WHERE clause

Post by ViktorV » Mon 27 Feb 2017 10:32

Thank you for your interest to our product.
If you have any questions during using our products, please don't hesitate to contact us - and we will try to help you solve them.

Post Reply