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
Can dropdowns be populated via SQL statements with Profound?
-
- New User
- Posts: 4
- Joined: Mon Aug 01, 2011 1:10 pm
- First Name: Donna
- Last Name: Wright Walsh
- Company Name: Genuine Parts Company
- Phone: 770 850 2419
- Address 1: 3100 Windy Hill Road
- City: Atlanta
- State / Province: Georgia
- Zip / Postal Code: 30039
- Country: United States
- Contact:
- Brian
- Profound Logic Staff Member
- Posts: 286
- Joined: Thu Apr 14, 2011 10:23 am
- First Name: Brian
- Last Name: May
- Company Name: Profound Logic Software
- Contact:
Re: Can dropdowns be populated via SQL statements with Profound?
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.
Who is online
Users browsing this forum: No registered users and 9 guests