Hello all,

In the .fex my SQLOUT looks something like this:

select distinct
spriden_pidm as "NPIDM",
spriden_id as "ID",
spriden_last_name || ', ' ||spriden_first_name || ' ' || substr(spriden_mi, 1,1) as "NAME",
ssbsect_camp_code as "CAMP",
stvdept_desc as "PROG",
decode(b.nbrjobs_ecls_code,'01','(F)','02','(F)','04','(F)',
'05','(F)','10','(F)','55','(F)','56','(F)',
'64','(F)','65','(F)','(P)') as "FTPT",
f.scbcrse_dept_code as "DEPT",
f_sjc_build_crse ( A.SIRASGN_PIDM,'200920',F.scbcrse_dept_code,'HTML' ) as "CRSE",
decode(c.scrattr_attr_code,'DEVL','(D)','DEVN','(D)','ACAD','(T)','(N)') as "DTYPE"

In the where clause I have some thing like this:

WHERE FTPT EQ '&FTPT';
WHERE CAMP EQ '&CAMP';
WHERE NAME EQ '&NAME';

Now, in my HTML, I have three listboxes that I want to use fields from SQLOUT.mas to populate the listboxes but the fields are not displaying for me to choose in Listbox - Dynamic - Datasource - SQLOUT.mas

How can I make the values to display in HTML?

Thanks,
Steven

This message has been edited. Last edited by: Kerry,

Steven,

The reason that you cannot see the fields is that they do not exist at the time you get to choose them within the HTML painter. You can either choose to populate your combo from a .fex (as opposed to a .mes), write the .mas file on a permanent basis or a myriad of other methods.

There have been many a post on this subject so it might be an idea to use the search function.

One such post had a reply from Susannah sugesting overnight execution of all the individual fexes and holding of the output etc. but you only have to search to get other answers.

T

Tony,

Thank you for your suggestions. I know how to to from a .fex but I am trying to do it from a .mas also. I did a search on datasource and I found a document about the reason they are not showing on the .mas, case number 31012549

Thanks,
Steven

Are you trying to use the HTML Layout Painter?

I would recommend that you use the "Procedure" method of populating your dropdown boxes since you don't have a master file description. There are lots of posts on this topic.

I was able to create a FOCUS file and it is working fine now.

Thanks,
Steven