Active Query Builder support area

How to add the DISTINCT keyword to the query programmatically?

Last modified:


Use the following code to insert the DISTINCT keyword into a query:
 
SQLSubQuerySelectExpression selexpr = queryBuilder1.ActiveSubQuery.ActiveUnionSubquery.QueryAST;
selexpr.SelectMode = new SQLSubQuerySelectModeDistinct(queryBuilder1.SQLContext);
queryBuilder1.ActiveSubQuery.ActiveUnionSubquery.NotifySQLUpdated();

Is this article helpful for you?