SQL*FORMS 3.0 Problem : DUPLICATES IN EXECUTE_QUERY.

From: Sanjeev.Agrawal <sanju_at_churchill.ColumbiaSC.NCR.COM>
Date: Thu, 03 Jun 93 20:42:30 GMT
Message-ID: <1993Jun03.204230.1745_at_ncrcae.ColumbiaSC.NCR.COM>


I am facing one problem in execute_query on a block.

Scenario is like this :

One template is made up of more than one group and a group in turn consists of more than one field.

Template layout, describing above relationship, is stored in one table and template_id + group_id + field_id is the unique key for the same. Therefore there are more than one record which have same template_id + group_id ( this equals to number of fields in the group).

I plan to query and modify the layout.

I have three blocks. First one just contains template id, second one for group details and the third one for corresponding field details so that when I enter the template id, I get all groups in the group block and the fields, corresponding to the current group , in the fields block.

Now when execute query on my group block, I can not use GROUP BY function and get same template_id + group_id more than once.

I can not use a view with a group by clause as I need to modify the layout. One way I feel is to create a table instead of view by using a group by clause.

Is there a better way to perform it ?

If possible please e-mail.

Thanks in advance, Received on Thu Jun 03 1993 - 22:42:30 CEST

Original text of this message