From: "Anatoly V. Lisovoy" <anatoly@nmb.ru>
Subject: Re: Forms 4.5: Select distinct...!!
Date: 1997/08/08
Message-ID: <01bca3ca$1e9f2a00$63d187c2@a-lisovoy.nmb.ru>#1/1
References: <01bca33c$0e374640$22f1acce@neutron> <33EA073B.1757@maderich.demon.co.uk>
Organization: Municipal Bank
Newsgroups: comp.databases.oracle.tools






Stuart Turton <sturton@maderich.demon.co.uk> çàïèñàíî â ñòàòüþ
<33EA073B.1757@maderich.demon.co.uk>...
> 1) Frig the SQL statement to be come a UNION or MINUS statement:
>    You can do this by appending something like 
> ' UNION SELECT .... from <table-name> WHERE 1 = 2'; 
> 
> 2) Put something in you POST-QUERY trigger which compares the current
> record with the previous record and fail if they match.
> 

Other way :

Write select in BASE_TABLE property of block U need : (SELECT DISTINCT
Field1 FROM TABLE WHERE CONDITION).
( ) - MUST PRESENT.

That's all.

Anatoly.