Devart Forums

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

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.

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

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

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.

Could you explain your idea in more details?