How to add the DISTINCT keyword to the query programmatically?

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.

How to change sorting, add filters, limits and aggregations to the query?
How to check if a query contains specific tables and they are joined correctly?
How to add or modify TOP, LIMIT, FETCH FIRST clauses or ROWNUM condition programmatically?
How to join an object that has just been added by the user with existing objects in the query?
How to take additional actions when user adds an object to the Design Pane?
How to add objects and joins to the query programmatically?
How to add the DISTINCT keyword to the query programmatically?
How to rename a table in the query (replace all occurrences) programmatically?
How to change aliases for query output columns programmatically?

Articles in this section