Re: Forms 4.5 Question

From: Geoff White <whiteg_at_ccis.adisys.com.au>
Date: Tue, 11 Jan 2000 09:48:15 +0800
Message-ID: <387A8BDE.50F7D506@ccis.adisys.com.au>

Your description suggests that you have built a normal master/detail form and that your col_a is not unique. If my assumptions are correct then in your where clause property try:

rowid in
(select min(rowid) from this_table
group by col_a)

HTH
Geoff

KRM wrote:

> Hello.
> <snip>
> I was able to create the following query in SQL-Plus, and it returned
> only unique values. However, when I take the where statement (w/o the
> where) and put it into the where clause of the block, nothing is ever
> returned. Here is a modified version:
>
> Select col_a from this_table where rowid in
> (select min(rowid) from this_table t
> where t.col_a = this_table.col_a)
> <snip>

> Thanks,
> KRM
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Jan 10 2000 - 19:48:15 CST