I have a fex that pulls a list of files names from a directory using FOCAPPQ. It works fine when run standalone.

  APP QUERY CLECO_TEMP HOLD
TABLE FILE FOCAPPQ
PRINT FILENAME
ON TABLE PCHOLD FORMAT XML
END

But when used as the source for a drop-down, the control receives an error populating.

I imagine that it has to do with the creation of the temporary hold file. Any ideas welcome!

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

APP QUERY CLECO_TEMP HOLD
-RUN
TABLE FILE FOCAPPQ
PRINT FILENAME
BY FILENAME
WHERE FILAENAME CONTAINS '.mas';
ON TABLE PCHOLD FORMAT XML
END

I created a quick html page with Dev Studio HTML Painter with a dynamic "List box" populated by a procedure containing your exact code and the list box gets populated.

Perhaps something else is causing it to fail. There are logs somewhere where you can check for errors.

Tom,

Yes, I think this has come up before - in certain cases you need to supply two columns - the "code" value and the "display" value, though in my simple HTML page, whether or not I check "Send display value", my procedure passes only one column and it all holds together.

"FILAENAME"?

ThHat took care of it! Thanks much. I had spent much time trying to figure out something so simple!

quote:

"FILAENAME"

OOPPSS! Good catch F.M. EL TYPO!