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 create a simple query programmatically?
How to change sorting, add filters, limits and aggregations to the query?
How to specify the stored procedure parameters programmatically?
Generation of INSERT, UPDATE, DELETE statements for a given SELECT statement
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?

Related articles

Articles in this section