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();