Can dropdowns be populated via SQL statements with Profound?

[dwrightgrinch]

We have a SQL statement (that I thought could be used instead of doing within RPG SQL stmt) we want to use to populate a dropdown. Can this be done within a function/selection of ProfoundUI where there is no SQL stmt put in the RPG code? I don't want to do this with javascript either. If so, how would this be done?

Here's the SQL stmt:
Select b.cddesc fROM MAPGP as A join SYCDP as B on a.pgpgcd
=b.cdcode where a.pgpcd = 'NA' and b.sysys = 'MA' and b.cdtype =
'PROG' and a.pgtype = ' ' order by b.cddesc

Thanks, Donna Wright Walsh
GPC 770 850 2419

[Brian]

That statement contains a join which our Database-Driven Selection will not support directly. However, you could create an SQL view from that select statement and then use the view for the Database-Driven Selection parameters.