Re: Forms: Select Distinct
Date: 2000/03/02
Message-ID: <89kn5b$si0$1_at_gossamer.itmel.bhp.com.au>#1/1
Hi Rainer,
You could base your form on a database view, which itself selects distinct.
Since the table has 5 rows, it hardly seems worth it.
The alternative is to set the block where clause to something like:
tablename.uniquekey in (select t.uniquekey from tablename t where t.number1
= tablename.number1 and t.number2 = tablename.number 2 and t.date =
tablename.date and rownum = 1)
It works in SQL but I've never tried using rownum in a Form.
Rainer Kagerer wrote in message
<066c66cb.995387bf_at_usw-ex0106-045.remarq.com>...
>Hi!
>
>I have got a table with 5 columns in and want to select 3 of
>them with a select distinct.
>a number
>b number
>c date-time yyyy-mm-dd-hh24-mi-ss
>
>And I want to get all columns with a,b and c yyyy-mm but not
>duplicate.
>What do I have to do? Is there any property to be set?
>
>
>* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
>The fastest and easiest way to search and participate in Usenet - Free!
Received on Thu Mar 02 2000 - 00:00:00 CET