|
<< Click to Display Table of Contents >> RpReport:SQLDistinct Access/Assign |
  
|
RpReport:SQLDistinct Access/Assign
|
<< Click to Display Table of Contents >> RpReport:SQLDistinct Access/Assign |
|
| 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 to include the DISTINCT keyword when a SQL SELECT statement is issued.
Example
// 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. |