Re: Forms 4.5: Select distinct...!!
From: Anatoly V. Lisovoy <anatoly_at_nmb.ru>
Date: 1997/08/08
Message-ID: <01bca3ca$1e9f2a00$63d187c2_at_a-lisovoy.nmb.ru>#1/1
Date: 1997/08/08
Message-ID: <01bca3ca$1e9f2a00$63d187c2_at_a-lisovoy.nmb.ru>#1/1
Stuart Turton <sturton_at_maderich.demon.co.uk> çàïèñàíî â ñòàòüþ
<33EA073B.1757_at_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. Received on Fri Aug 08 1997 - 00:00:00 CEST