Re: Modify block-definition in SQL*FORMS

In article <s897336.719471561_at_rubicon>, s897336_at_rubicon (Soh Lip Meng-Master) wrote:
>
> Can any netter teach me how to modify the JOIN-condition in the Block-definition( SQL*FORMS design ) ?
> To be specfic, my problem is that I could only find the JOIN-condition specification column in the DEFAULT-BLOCK, but not in the MODIFY for the BLOCK-definition!

You could modify the join condition in the .inp file (if you're using V3), but the reason that it is only available in the default block definition is that when you commit the default detail block, SQL*Forms write a whole bunch of triggers for you to coordinate the two blocks.

SQL*Forms does not have any way to re-write the triggers it built if you were to change the join.

Suggestion. Create a new default detail block, and throw the old one away.

(Also, keep this in mind in the future when your in the design phase :-)).

-Devan

                             
               Devan F. Dewey | Senior Systems Analyst
          CenterLine Software | dewey_at_centerline.com
            10 Fawcett Street | "Leme esplain - no dere is
          Cambridge, MA 02138 | too much. Leme sum up."
                                       -Inigo Montoya