Pagelet with Prompts Issue
Her latest one needs to prompt against the PS_JOBCODE_TBL, which appears to be the first itme she's had one that needed to specify a SETID value. Once we got the query working (you have to be sure to prompt the user for the SETID first, then the JOBCODE value) the query works great. But when she puts it into a pagelet, it doesn't work. She specified default values for both SETID and JOBCODE and it works for those, but when you use the pencil to change the values, it won't show any JOBCODE values. Basically, it's like the prompt for