Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!csd4.milw.wisc.edu!lll-winken!uunet!mcvax!ukc!axion!slxsys!ibmpcug!alanj
From: alanj@ibmpcug.UUCP (Alan Jay)
Newsgroups: comp.databases
Subject: Re: Problem with Clipper a'86
Message-ID: <10660@ibmpcug.UUCP>
Date: 27 Apr 89 17:52:47 GMT
Organization: The IBM PC User Group, UK.
Lines: 49

Hi,

I hope this helps I have been using Clipper for some time but have never
had your particular problem.  I now use Summer 87 (which works pretty well 
as a programming language even if the environment's not great).

Now your problem:

In article <1081@haydn.kulesat.uucp> lily@haydn.kulesat.uucp writes:
>Now, sometimes when SEEK-ing a
>record (with the right index file opened) Clipper can't find it.
>Found() becomes .F. although I'm perfectly sure that the record is
>in the database.  

I have had problems seeking the solutions iahve used are along the following
lines:

Check that the item you are seeking can be found TRIM the variable
is EXACT ON etc.  This can be quite important even with simple keys.  Even
if you think its right test it out with dBASE III, Fox or DBXL they should give
give the same results (if you can get access to a copy).  (This is one of 
the gripes with using Clipper bad development environment).  If the construct
works then the index may be corrupt.

>I tried solving the problem by REINDEX-ing, but
>it didn't work. 

I thought by now everyone had had someone tell them the REINDEX can seriously 
damage your health, wealth and beauty sleep.

I now always use INDEX to recreate index files.  I have recently had it 
sugessted that one should even go so far as to delete the index file
before INDEX ON (ah well it makes life interesting).

Alan Jay

PS Does any one have any other views on the INDEX, REINDEX, delete before INDEX
problem.  It all seems like its rather circumstantial.


-- 
Automatic Disclaimer:
The views expressed above are those of the author alone and may not
represent the views of the IBM PC User Group.
-- 
Alan Jay @ The IBM PC User Group, PO Box 360, Harrow HA1 4LQ ENGLAND
Phone:	+44 -1- 863 1191			Email:	alanj@ibmpcug.CO.UK
Path:	...!ukc!slxsys!ibmpcug!alanj		Fax: +44 -1- 863 6095
Disclaimer: All statements made in good faith for information only.