Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!wuarchive!gem.mps.ohio-state.edu!apple!usc!henry.jpl.nasa.gov!elroy.jpl.nasa.gov!hacgate!ashtate!dbase!awd
From: awd@dbase.UUCP (Alastair Dallas)
Newsgroups: comp.databases
Subject: Re: dBASE IV (Again)
Summary: More detail, please
Keywords: dBASE
Message-ID: <268@dbase.UUCP>
Date: 3 Oct 89 17:27:56 GMT
References: <248@cerc.wvu.wvnet.edu.edu> <266@dbase.UUCP> <256@cerc.wvu.wvnet.edu.edu>
Organization: Ashton Tate Devlopment Center Glendale, Calif.
Lines: 43

Excuse me for posting to the net--I can't reach Boris by email and I'd like
to solve this problem.

In article <256@cerc.wvu.wvnet.edu.edu>, coop@cerc.wvu.wvnet.edu (Boris Pelakh) writes:
> In article <266@dbase.UUCP>, awd@dbase.UUCP (Alastair Dallas) writes:
> > I went to duplicate your bug.  I created a 1518-record file and did:
> > 
> > 	APPEND BLANK
> > 	x = recno()
> > 	<some operations>
> > 	GOTO x
> > 
> > This doesn't cause any problem for me.  Of course, it could be that I
> > picked different operations to try :-).  Could you be more specific?
> >
> I found a most interesting quality in this error. In the <some operations>
> block, I was modifying the field that was the current key field. Somehow,
> it was not entered into the index (AUTOSAVE matters ?!) and when trying to go
> to it, it was giving the out-of-range. If a reindex was put before the goto
> statement, all went smooth. Could that be the reason ?
> 
> Boris Pelakh.					"Software - a spell one casts
> pelakh @ cerc.wvu.wvnet.edu 			 on a computer to transform
> 						 input into errors."
> 								- Me.

I still need more information to recreate the problem.  What I have is:
Create a 1518-record file indexed on a field called Key.  Then:

	APPEND BLANK
	x = recno()
	REPLACE Key with "Something"
	GOTO x

This does not fail for me on the version you have, which we call x322
internally.  No, AUTOSAVE should not matter here.  What might matter is
if the index is UNIQUE, and the "out-of-range" error is not "Record out
of range" but rather "Record not in index".  I need the exact details
of your environment and what steps come between APPEND BLANK and GOTO
in order to track this down.  You've really got me curious, that's for
sure!

/alastair/