Re: Oracle Developer Question
From: Paul Dorsey <pdorsey.dulcian_at_worldnet.att.net>
Date: 1998/10/15
Message-ID: <703hfn$c3p_at_bgtnsc01.worldnet.att.net>#1/1
2) You could hook your block to a view.
3) And for the truely twisted, you can relay on the fact that forms does not display records where a pop list fails. Put in a poplist that is not displayed in the block connected to empid with only the values from 1) in it.
I.M. Snyder figured that one out.
Date: 1998/10/15
Message-ID: <703hfn$c3p_at_bgtnsc01.worldnet.att.net>#1/1
Nothing pretty.
1) You can use a wierd default where clause, e.g.
empid in (select min(empid) from emp
group by deptno))
2) You could hook your block to a view.
3) And for the truely twisted, you can relay on the fact that forms does not display records where a pop list fails. Put in a poplist that is not displayed in the block connected to empid with only the values from 1) in it.
I.M. Snyder figured that one out.
Solution 3) avoids the subquery so may be faster in some cases.
-- Paul Dorsey Dulcian, Inc. www.dulcian.com 212 595 7223 Alnoor Issa wrote in message <3622CD23.C83E41F7_at_mail.idt.net>...Received on Thu Oct 15 1998 - 00:00:00 CEST
>
>
>Hello,
>
>I am working on a Form(4.5) with one simple Block, for e.g EMPLOYEE Block.
I
>have selected ONLY deptno on my block.
>I would like to select only DISTINCT deptno for my employee block.
Currently I
>am getting multiple deptno. Is there any way to use " Select distinct
deptno
>from employee" and show the values on the employee block?
>
>I was thinking of using On-Select trigger but it did not work.
>
>
>I will very much appreciate if someone can help me in this regard.
>
>Thank you.
>
>Alnoor Issa
>issa_at_idt.net
>