Re: Forms 4.5: Select distinct...!!

[Quoted]
1. Frig the SQL statement to be come a UNION or MINUS statement: [Quoted] You can do this by appending something like ' UNION SELECT .... from <table-name> WHERE 1 = 2'; [Quoted]
2. Put something in you POST-QUERY trigger which compares the current record with the previous record and fail if they match.

Claude Ramazzini wrote:
>
> Hi everybody,
> do someone know how to do a SELECT DISTINCT
> into forms 4.5? I know that we can control in the properties of the bloc
> the ORDER BY and the WHERE clause, but is there a trick to modify the
> SELECT statement of Oracle to introduce the DISTINCT clause?
>
> Thanking you in advance,
>
> Claude Ramazzini
> Production Engineer
> airborne_at_sympatico.ca
> Airborne Gear and Mach. Ltd
> tel: (514) 325-9000 ext. 4
> fax: (514)325-3265
>
> ** If there is so many things to configure in Linux, maybe this is because
> it is doing so much.
Received on Thu Aug 07 1997 - 00:00:00 CEST