Re: Oracle Developer Question

Here are some things that come to mind:

• base the block on a view that includes a distinct in its query.
• on-select is used in conjunction with on-fetch.
  • paulastya gupta

Alnoor Issa wrote:
>
> 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
Received on Thu Oct 15 1998 - 00:00:00 CDT