Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!iuvax!watmath!xenitec!timk
From: timk@xenitec.uucp (Tim Kuehn)
Newsgroups: comp.databases
Subject: Re: Clipper/dBase Seek Question
Summary: set softseek on
Keywords: seek, 2 indexes, seek on first index only
Message-ID: <1989Aug22.130839.25372@xenitec.uucp>
Date: 22 Aug 89 13:08:39 GMT
References: <238@fltk.UUCP>
Reply-To: timk@xenitec.UUCP (Tim Kuehn)
Organization: Xenitec Consulting Services, Kitchener, ON
Lines: 24

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?

IF you set SOFTSEEK ON, and then do your seek, the record pointer will be 
left at either the desired entry, or at the first entry *greater* than the
specified seek string. You would need to setup your seek condition so:

set softseek on
seek str(invnum,4) + space(6)

+-----------------------------------------------------------------------------+
|Timothy D. Kuehn	       			       timk@xenitec	      |
|TDK Consulting Services			       !watmath!xenitec!timk  |
|871 Victoria St. North, Suite 217A					      |
|Kitchener, Ontario, Canada N2B 3S4 		       (519)-741-3623 	      |
|DOS/Xenix - SW/HW. uC, uP, DBMS. 		       Satisfaction Gauranteed|
+-----------------------------------------------------------------------------+