Has anyone made the FIND command work with SQLOUT.

For example, this doesn't work.

'&STATE.(FIND STVSTAT_CODE IN SQLOUT).Choose a STATE.';


I've even tried ON TABLE HOLD AS TEMPSTAT FORMAT FOCUS after getting my data through sqlpassthru.

And then tried issuing '&STATE.(FIND STVSTAT_CODE IN TEMPSTAT).Choose a STATE.';

In both cases it can't find the description of the file. Well, both are temporary files which is what I want, since I'm creating dynamic dropdown list.

Thanks,
Nate

Nate

This subject has been covered recently, and you might want to search the Forum.

Basically auto prompt searches through the focexec for unresolved amper variables, it will run no code at this stage. It will then present the auto prompt screen to the user. After the user has made the selection the reports or any other code runs.

So you may want to consider another approach to this. Coding your own launch page rather than relying on auto prompt

Nate,
I agree with Alan. You need some type of self-service app which will populate a listbox with the data retrieved in SQLOUT. That is what we do.

I did some searching and could not find that recent post you had mentioned. Do you remember the post or example. It would be handy if one could insert a link to a related post.

Thanks in advance,
Nate

Nate
I think the topic I was thinking of is.

https://forums.informationbuilders.com/eve/forums/a/tpc/...271012512#7271012512

Nate,

What is the code for the SQLOUT file?

If it is not too complicated you may be able to put it into the FIND directly.

Thanks Alan. For that link to that previoius post. Very helpful. I like that requested feature you proposed. How do I support it?

Tom, your idea includes APP HOLD FOLDERNAME. Wouldn't this cause a few issues if multiple users hit the same report at the same time? It would be overwriting the HOLD file for the other user. Or not, I haven't tried this. I may have to try this.

Alan,

Here's the sql:

ENGINE SQLORA SET DEFAULT_CONNECTION PBAN
SQL SQLORA PREPARE SQLOUT FOR
SELECT DISTINCT STVSTAT_DESC, STVSTAT_CODE
FROM SOBSBGI, SHBTATC, STVSBGI, SHRTATC, STVSTAT
WHERE STVSTAT_CODE(+) = SOBSBGI_STAT_CODE
AND SHBTATC_SBGI_CODE = SOBSBGI_SBGI_CODE
AND SOBSBGI_SBGI_CODE = STVSBGI_CODE
AND SHRTATC_SBGI_CODE = SOBSBGI_SBGI_CODE
AND STVSBGI_TYPE_IND = 'C'
AND STVSBGI_DESC > 'A'
AND SHBTATC_TAST_CODE = 'A'
AND STVSTAT_CODE IS NOT NULL
AND SHRTATC_TERM_CODE_EFF_TRNS = SHBTATC_TERM_CODE_EFF_TRNS
AND SHRTATC_SUBJ_CODE_TRNS = SHBTATC_SUBJ_CODE_TRNS
AND SHRTATC_CRSE_NUMB_TRNS = SHBTATC_CRSE_NUMB_TRNS
ORDER BY 1;
END

I don't think I can fit that in a FIND statement without using that APP HOLD command if that indeed won't create additional problems.

Thanks,
Nate

thanks, tom