dependent queries in templates?

[Kent]

I am trying to create a template that will populate a list box from a query, and then populate a second list box from a query based on the user's choice in the first box. Is this possible? Or do all the $QUERY statements just run at the beginning of the template execution?

Here is what I am trying:

[$QUERY tables_and_views =
        select lower(object_name) from user_objects
        where object_type in ('TABLE', 'VIEW')
        order by object_type, object_name]
[$QUERY table_columns =
        select lower(column_name) From user_tab_columns t Where t.table_name = '[Table or view = $tables_and_view]'
        order by column_name]

Thanks for any answers.

 

[Marco Kalter]

This is currently not possible. It's on the to-do list though.