Re: Forms II: execute_query, DISTINCT

Gudrun Janssen wrote in message <36E53574.B4D2611D_at_itu.fzk.de>...
>Hi,
>
>I want to make a query to a block using the
>execute_query built-in. Does someone know,
>how to make this query a 'distinct-query'? I
>mean:
>select distinct ...
>
>The only way I figured out is to set the default-
>where to something like:
>' 1 = 1 INTERSECT (select distinct ...))'
>
>That works, but I think there must be a better
>way.
>
>Thanks
>Gudrun
>
>

Suggestion - Base the block on a view:

create view xxx
as select distinct...

This may not be the best solution, but it should work in any Forms-version.

Regards,

Roy Brokvam
roy.brokvam_at_conax.com Received on Wed Mar 10 1999 - 13:34:04 CET