Re: Forms4.5 Question

zhou_at_igd.fhg.de (Zhou Jian) wrote:
>I wonder how to modify the FROM clause dynamically, for
>example, in a PRE-QUERY trigger?
>In my form application, I have a base table block. However, I need to expand
>the Where clause to include a join with other tables
>in a PRE-QUERY trigger.
>Is there any possibility to modify the FROM claus dynamically?

It doesn't sound like you need to modify the FROM dynamically, but rather build your base table block based on a view (which includes your subquery, or join, or whatever).
 If you really do need to change your join dynamically (i.e. your user can choose to see employees based on last paycheck date or utilization time - both stored in separate tables from your employee data), you can even recreate the view from forms with the correct where clause using the forms_ddl(create_clause) built-in. Be forewarned though, that if it is truly a join (as opposed to a subquery) then you will be unable to insert, update, delete through the view without writing your own transactional triggers.

>Jian Zhou

I must admit, this not a solution that I devised, but hey, as they say "Good Artists Borrow, Great Artists Steal." - Dave Sloan
dsloan_at_us.oracle.com Received on Mon Aug 07 1995 - 00:00:00 CEST