How do I set DWDD to select DISTINCT values?

[Andyfives]

Hi there,

I am very new to Powerbuilder 11.5, but now I'm using it on a daily basis and I am on a mission to get my head around it.

This is probably a simple task, but I have a dropdown window that has a source that has duplicate values where they are not needed and I would like to get rid of these.

I see the SQL

SELECT USERS.USERID,   
         USERS.FIRST_NAME,   
         USERS.LAST_NAME  
    FROM USERS

but I can not change it in the DataSource (painter?) where can I set this to make a simple SELECT DISTINCT?

Thanks in advance.

I hope there is somebody out there....

Andy

 

[thekl0wn]

Open the DDDW's DataWindow Painter. Go to the SQL source. Under the Design menu, select "Convert to Syntax" if you're not already there, and either use the SELECT DISTINCT clause or a GROUP BY clause.

 

[Andyfives]

That is perfect.

Thank you.

I couldn't see that for looking!

Andy