Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!iuvax!rutgers!usc!henry.jpl.nasa.gov!elroy.jpl.nasa.gov!hacgate!ashtate!dbase!awd
From: awd@dbase.UUCP (Alastair Dallas)
Newsgroups: comp.databases
Subject: Re: Clipper/dBase Seek Question
Summary: SET EXACT OFF
Keywords: seek, 2 indexes, seek on first index only
Message-ID: <201@dbase.UUCP>
Date: 23 Aug 89 16:58:29 GMT
References: <238@fltk.UUCP>
Organization: Ashton Tate Devlopment Center Glendale, Calif.
Lines: 23

In article <238@fltk.UUCP>, dnb@fltk.UUCP (David Buonomo) writes:
> I have a .DBF file indexed on 2 numeric fields of 4 and 6 digits respectively.
> More specifically, the index is built by:
> 
> 		index on str(invnum,4)+str(seqnum,6) to idx_file
> 
> I would like to do a seek specifying only the first index.  I am currently
> unable to accomplish this (result of seek is EOF).  Is this possible to do
> and if so, how?

Is this a Clipper problem?  In dBASE, as long as SET EXACT is OFF, you can

	SEEK "A"

and find "Alastair".  In this case you can

	SEEK STR(4892,4)

and find "4892100321".  In other words, your approach seems valid, from the
information you've given.  Perhaps with more information, the problem will
be clearer...

/alastair/