Underlying Query property

Previous Next

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

NOTE: 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.