Re: Displaying distinct rows in Forms 4.5 block?
From: Vincent Moynihan <vince_at_vmoy.demon.co.uk>
Date: Sat, 06 Jun 1998 10:52:48 +0100
Message-ID: <35791170.784F25BF_at_vmoy.demon.co.uk>
Date: Sat, 06 Jun 1998 10:52:48 +0100
Message-ID: <35791170.784F25BF_at_vmoy.demon.co.uk>
igal_at_healthstreet.com wrote:
> Hello everybody,
> My block is based on several fields from a view. However, I'm displaying only
> 3 of those fields. (I use the others in the WHERE clause) Is there a way to
> show only distinct occurences of those 3 fields?
> Thanks,
> Igal
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
Consider replacing the base table property of the block with an in-line view. For example,
(SELECT DISTINCT COL1,COL2 FROM VIEW1). It works, but I guess that using in-line views may have a performance overhead over using view with the same query. Received on Sat Jun 06 1998 - 11:52:48 CEST