DataSource.DataSet.CommandText

[heerdinm]

Hello,

I am converting my ADODataSource to a TUniDataSource.
With an ADODataSource, i can do something like this:

TADODataSet(DbGrid.DataSource.DataSet).CommandText

I would like to do the same with UniDAC.
What i have now is:

TUniDataSource(DbGrid.DataSource).DataSet.

I can not use CommandText, because it is not part of the TUniDataSource property list.
What i would like is the currently used SQL in the DataSource. How should i be doing this to get the SQL that is used?

I use a TUniDataSource with a TUniTable.
If i should be using other components, please do tell

[heerdinm]

Ok, i found:

TUniTable(grd.DataSource.DataSet).FinalSQL

Would be happy to know if i am still on the right track.
I have used TADOData.... for so many years now that i kind of forgot how it is done without them

[AlexP]

Hello,

To get the text of the SQL query being executed, you can use the FinalSQL property, in this case the final query will be displayed (including all conditions added with the help of the methods AddWhere, FilterSQL, etc.), to view the initial SQL query, you can use the BaseSQL property.