Help! (SCO FoxBASE+)

[Bruce A. McIntyre]

In article <32 at agtoa.UUCP>, greyfox at agtoa.UUCP (Bruce Ide) writes:
> I'm having serious difficulty getting SCO FoxBase+ to index. This is what
> happens:
>[description deleted ] 
>  file is in use
> 
> The runaround if I have ever seen one. Dogname is part of the data base
> structure, and a smaller version of the file will index perfectly. The 
> large version is 1.27 megabytes, and the small version isn't more than 
> two or three Kbytes. Ulimit allows for files up to one Gigabyte, so
> that's not the problem. Also, when I restore the file and the old index
> off of backup and reindex, it says "file not found". 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.
>               -Bruce   uunet!agtoa!greyfox 

I have shipped several systems with large files (multi-mega) under Foxbase
and Xenix, (V2.2.3) and found that usually the error is caused by file
protection.   If you don't have write permission in the directory, yu
can't index.  If the index is owned by someone else, and you don't have
write permission, you will get the "file in use" error or if you don't have
read permissions, it will get a "file not found".

Make sure that all indexes are set to the right permissions, see if they
are _rwxrwxrwx to insure that they don't have problems, or make sure that
all users are in the same group and set them _rwxrwxr__.  You will find most
of your problems will disappear.  In your code, right after you do an index,
call a "run chmod ug+rw indexname.ndx" and that will fix it... 

I hope that this gets rid of your problem..

bruce
-- 
=========================================================================
	Bruce A. McIntyre, McIntyre Designs, Inc. VOICE(215)322-1895
	143 Bridgetown Pike, Langhorne, Pa. 19047 DATA (215)357-2915
	{wells|lgnp1}!mdi386!bruce		bruce at mdi386 tbit+