Page 1 of 1
GET WHERE clause
Posted: Fri 24 Feb 2017 01:40
by cybsistemas
Hello
How do I find out the WHERE clause of a query?
Thanks
Re: GET WHERE clause
Posted: Fri 24 Feb 2017 09:33
by ViktorV
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.
Re: GET WHERE clause
Posted: Sat 25 Feb 2017 04:08
by cybsistemas
Thank you very much ViktorV
Re: GET WHERE clause
Posted: Mon 27 Feb 2017 10:32
by ViktorV
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.