Maybe a suggestion

[jalin]

I was trying to find the way to create dinamically the select statement of a SQL. Is there a way to create the SELECT statement using something like ADDWHERE or ORDERBY methods?

Thanks in advance
Jalin

[Dimon]

To create a query dynamically you can use the following TCustomMyDataSet methods:
AddWhere, DeleteWhere, GetOrderBy, SetOrderBy, FilterSQL.
You can find more detailed information about these methods in the MyDAC help.

[jalin]

These methods modify the SET ORDER BY and WHERE clauses but not the SELECT clause

[Dimon]

You should use the TCustomMyDataSet.SQL property and set the SELECT statement like this:

Code: Select all

MyQeury.SQL.Text := 'SELECT * FROM tablename';

[jalin]

Yes of course, this is the common way to do it and many times you can use the ADD method SQL.ADD('SELECT....´) but I was looking something more dinamic. Maybe Im not explaining my idea.

[Dimon]

Could you explain your idea in more details?