Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!mailrus!uwm.edu!uakari.primate.wisc.edu!aplcen!haven!udel!princeton!njsmu!mccc!labii!shevett
From: shevett@labii.UUCP (Dave Shevett)
Newsgroups: comp.unix.xenix
Subject: Re: Help! (SCO FoxBASE+)
Keywords: FoxBASE+, Index, File error
Message-ID: <230@labii.UUCP>
Date: 26 Oct 89 01:33:59 GMT
References: <32@agtoa.UUCP>
Distribution: usa
Organization: Labyrinth II BBS - W. Trenton, NJ
Lines: 46

greyfox@agtoa.UUCP (Bruce Ide) writes:

>I'm having serious difficulty getting SCO FoxBase+ to index.
[...]
>.use mainm

Betcha this dbf has a memo field in it

>.index on dogname to dog
> file not found
>.index on dogname to dog
> file is in use
>... Same goes for 
>PACK ALL and PACK. Does anyone out there have an idea as to what the
>problem may be? This is SCO XENIX V2.2.3 SYS V, foxbase version 1.0.3.
>Reply to me using mail, unless everyone else on this discussion would be
>keenly interested in the solution. Thanks.

I'm posting the reply because this problem stumped Fox also.  SCO couldn't
make heads or tails of it.  THe problem is in a temporary file made when
a database containing MEMO fields is reindexed.  I believe the file has
a .TBK extension.  If you try to reindex or pack a database with a memo
field, and the file database.tbk does not exist, FoxBase sometimes throws 
up and starts giving false errors.  

	I just made a db called 'try' on my SCO 386 2.3.1 system, 
with 3 fields.  A and B are chars, C is a memo. Indexed on A.  
A reindex with 0 records worked.  I added in a bunch of
records and they reindexed.  I did a 'delete all', then 'pack' and came
up with 'file does not exist'.  Unfortunately, this error also screws
up the open dbf tables, so you have to do 3 things before reindexing : 

.!>try.tbk
.close all
.use try index try
.reindex

I just got a flyer from SCO saying they have a free update for FoxPlus
that fixes some other problems.  Wonder if they fixed this? 

>              -Bruce   uunet!agtoa!greyfox 

/--------------------+ 'The shortest distance +------------------\
|    Dave Shevett    |  between two puns is a | Labyrinth II BBS |
| shevett@labii.UUCP |  straight line...'     |  W. Trenton, NJ  |
\--------------------+       - Doc Webster    +------------------/