SQL*FORMS 3.0 Problem : DUPLICATES IN EXECUTE_QUERY.
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