RpSQLQuery:SQLDistinct Access/Assign

<< Click to Display Table of Contents >>

Navigation:  RpSQLQuery Class >

RpSQLQuery:SQLDistinct Access/Assign

Previous pageReturn to chapter overviewNext page
Type        Logic

Purpose

To determine or set whether or not the DISTINCT keyword is used in the SQL SELECT statement.  Setting this assign to TRUE forces the rpSQLQuery object to include the DISTINCT keyword when a SQL SELECT statement is issued.

Example

// Force ReportPro to issue SELECT DISTINCT for this query

oQuery:SQLDistinct := TRUE