Re: Displaying distinct rows
From: Rainer Bielefeld <Rainer.Bielefeld_at_tui.de>
Date: Fri, 26 Feb 1999 11:09:41 +0100
Message-ID: <36D672E5.17F36103_at_tui.de>
Date: Fri, 26 Feb 1999 11:09:41 +0100
Message-ID: <36D672E5.17F36103_at_tui.de>
Hi,
create a View: create view "VIEW" as select distinct column_name from table_name...
This View can you use for the Data-Block.
Rainer Bielefeld
Louis Spies wrote:
>
> Hi,
>
> In Forms 5.0 I want to display data in a block based on a table.
>
> I only want to display one column of the table, which is not the primary
> key, and only distinct rows.
>
> Does anyone know how I can do this?
>
> Thanks in advance
>
> Louis Spies
Received on Fri Feb 26 1999 - 11:09:41 CET