Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!samsung!raybed2!rayssd!anomaly!mpd
From: mpd@anomaly.sbs.com (Michael P. Deignan)
Newsgroups: comp.databases
Subject: Re: CLIPPER array dups problem
Message-ID: <1991Apr26.215948.15296@anomaly.sbs.com>
Date: 26 Apr 91 21:59:48 GMT
References: <22963@gremlin.nrtc.northrop.com>
Distribution: usa
Organization: Small Business Systems, Inc., Esmond, RI  02917
Lines: 21

maurit@nrtc.nrtc.northrop.com (Mark Aurit <maurit>) writes:

>I APPEND it into a database, delete the first line, pack the file, read
>it into an array, then achoice() it.				   ^
								   |

Why not add two commands here:

SET UNIQUE ON
INDEX ON <key> TO <tempfile>


This will index the file, leaving the index active, and allow you to
then read the data into an array, without dups.

MD
-- 
--  Michael P. Deignan                      / Since I *OWN* SBS.COM,
--  Domain: mpd@anomaly.sbs.com            /  These Opinions Generally
--    UUCP: ...!uunet!rayssd!anomaly!mpd  /   Represent The Opinions Of
-- Telebit: +1 401 455 0347              /    My Company...