RpReport:SQLDistinct Access/Assign

<< Click to Display Table of Contents >>

Navigation:  RpReport Class >

RpReport:SQLDistinct Access/Assign

Previous pageReturn to chapter overviewNext page
Type        Logic


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 to include the DISTINCT keyword when a SQL SELECT statement is issued.


// Force ReportPro to issue SELECT DISTINCT  

oRpReport:SQLDistinct := TRUE

Note:        This access/assign maps directly to the first table object in the primary section.  It only applies if the first table object is a rpSQLQuery.