[comp.databases] Clipper/dbase index files

csc@chinet.chi.il.us (Craig Curtin) (08/22/89)

Help, the following stub is from a clipper program that is causing me lots
of havoc. 
Here is what i think i am doing. 
After USEing the file, check to see if the index file is present, if so
just use the "set index" command to the associated index file, if the index
is not present we have to build the index and then use the "set index" command.
The program works fine when the data file is present, and crashes the system
when not present but creates the index file successfully. if it gets run
a second time the program works successfully (hence falling into the top
of the if/endif loop). this is summer '87 clipper and ms-dos 3.31.

       >if !neterr() 	&& check for an error on the network
       >	if file ("DATA"+indexext())
ok     >		set index to data
       >	else
       >		* file not present, need to build it
error  >		index on var+str(row,2) to data
       >		* set index to data
       >	endif
       >endif
       >? "index with ["+indexkey(0)+"] as the key"
again the second time the code is executed it falls into the true section
of the if/endif statement, so that is telling there is no problems with
the index file that is being built. ???

thanks for any input.
-- 
craig curtin
email: chinet!csc
days : (312)985-9000x2376
nites: (312)416-0270