How to add the DISTINCT keyword to the query programmatically?

Sergey Smagin (Product manager)

March 22, 2017 06:30
Updated

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

Comments

0 comments

Please sign in to leave a comment.