Underlying Query property

Previous Next

This is where you specify the SQL statement that the selected Query object uses to retrieve data.


If you change the underlying query to something like the following, you must also set the Oracle ROWID property to No:

SELECT DISTINCT <non-key column>

FROM <mytable>

Otherwise the DISTINCT clause will apply to the (implicitly used) ROWID instead of the non-key column. The "same" data might then appear to be displayed more than once.