Relay-Version: version B 2.10 5/3/83; site utzoo.UUCP
Path: utzoo!utgpu!water!watmath!clyde!rutgers!sri-spam!ames!ucbcad!ucbvax!decvax!tektronix!reed!percival!leonard
From: leonard@percival.UUCP
Newsgroups: comp.sys.ibm.pc
Subject: Bug in dBase III +
Message-ID: <690@percival.UUCP>
Date: Tue, 9-Jun-87 16:45:39 EDT
Article-I.D.: percival.690
Posted: Tue Jun  9 16:45:39 1987
Date-Received: Sat, 13-Jun-87 06:40:56 EDT
References: <184@hubcap.UUCP>
Reply-To: leonard@percival.UUCP (Leonard Erickson)
Followup-To: comp.sys.ibm.pc
Organization: Percy's UNIX, Portland, OR.
Lines: 29

In article <184@hubcap.UUCP> e270a01@hubcap.UUCP (Demetrios Yannakopoulos) writes:
>Try to "INDEX" a file ( not too big -- 2,500 records is enough) using
>the option "UNIQUE". I guarantee you the system will die in the middle of
>the "INDEX"ing process leaving the screen idle with the (promising) message :
>" 50% of the file is indexed...." !!!!!

Oh boy! Another one. 

We finally tracked down a problem involving trashed indexes to the the fact that
we had TALK set to OFF during a PACK. The bug shows up at 2048 records.

USE file INDEX index
SET TALK OFF
PACK
USE file INDEX index

And you get a cute little error message. #^^%#^*^&!

You might also try using SET UNIQUE and then indexing on a numeric field.
I did this to check on how many different values we were getting in our data
(range ~= 1 to 100). From a 20k record file I got 800 entries.... (yes these
*are* integers!) 


-- 
Leonard Erickson		...!tektronix!reed!percival!leonard
CIS: [70465,203]		...!tektronix!reed!percival!!bucket!leonard
"I used to be a hacker. Now I'm a 'microcomputer specialist'.
You know... I'd rather be a hacker."