Marco,
If I haven't requested this enhancement before, will do so now. I'm sure all your users would benefit from it.
I'd like to be able to prompt the user for a value, then use that value in a query variable in the same template.
For example, I have a unit testing script that tests new view results against the old view results. I'd like my template to prompt for a user variable, [view_name], then use that to fill the following query variable:
[$QUERY vw_cols =
SELECT column_name
FROM user_tab_columns
WHERE table_name = UPPER('[view_name]')
ORDER BY column_id]
I would use that column list to populate the various SELECT statements in my unit testing script.
Instead PSD tells me my SQL statement is invalid, which it would not be if [view_name] were substituted after user entry.