[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Distinct List (OpenInsight Specific) ====
=== At 19 MAR 1999 03:08:25PM S.Berger wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
I am looking for a way to pull out a distinct list. I have a table, PROTOCOL, in the table one of the fields is PI. THere can be many protocols that have the same PI. I want a list of all of the PI's that have a protocol, but I only want them to show up once each.



What do you think



S
</QUOTE>
----

=== At 22 MAR 1999 06:48AM Oystein Reigem wrote:  ===

<QUOTE>SB



Do you say you want a list of all the different values in a field? If that field is indexed you can do it programmatically with



list=Collect.IXVals(filename, fieldname)



that returns the list of index values for the specified indexed field in the specified file, or



Extract_SI_Keys(tablename, columnname, value, keylist)



that searches a Btree index for a specified value and returns a list of keys based on the search value.



(Or you might perhaps use a relational index.)



- Oystein -

</QUOTE>

----

=== At 22 MAR 1999 12:34PM SBerger wrote:  ===

<QUOTE>Thanks, that first one sounds like what I am looking for.



S

</QUOTE>

----

=== At 22 MAR 1999 02:01PM Oystein Reigem wrote:  ===

<QUOTE>SB,



It's fine as long as you haven't got *too* many values.



- Oystein -

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=5655141785E6CE85852567390069243D|View this thread on the  forum...]]