Subject Re: SEARCHING VERY LARGE FILE From AGOSTINHO <AGOSTINHOTEIXEIRA@YAHOO.COM> Date Wed, 01 Sep 2021 00:07:55 -0400 Newsgroups dbase.getting-started A special thanks to Mervyn Bick,Ken Mayers and Gaetano for your input. This method works as a charm in medium/small files, it is very simple with only a few lines of programming, every ones knows  that the incremental search is the actual way to go, similar to google search. Indexes works fine but it will reach only the information at the beginning of each records, this way of search is not efficient. I'll keep  on researching until I get a perfect method to get a good incremental search for my large databases. Once again thank you very much and have a wonderful day. Agostinho Ken Mayer, dBase, LLC Wrote: > On 8/31/2021 6:50 AM, Mervyn Bick wrote: > > On 2021/08/31 14:54, Ken Mayer, dBase, LLC wrote: > > > >> Have you tried looking at SEEKER, which ships with dBASE, and works > >> with local tables, or in the dUFLP, at SeekerSQL.cc class which is > >> meant to work with SQL server databases? (There is also an ADO version) > >> > >> SEEKER, which you would want to use with dBASE tables, which yours > >> seems to be requires an index that uses the UPPER() function on the > >> field used, but it works really well and is fast. > >> > >> set procedure to :FormControls:Seeker.cc > >> > >> Then open the form in the designer and place this control on your > >> form. It's that simple ... > > > > Agostinho is using  LIKE in his select statement and '%'+this.value+'%' > > as a parameter.  In other words he is looking for a match which may just > > happen to be at the beginning of the field but could be anywhere in the > > field's contents. > > > > A SEEKER uses an index and only moves the rowpointer to the first record > > that begins with the search value.  In other words it won't do what > > Agostinho needs. > > Well, there's no fast way to do what he wants, then ... > > Ken > > > -- > *Ken Mayer*, dBase, LLC > Ken's dBASE Page: http://www.goldenstag.net/dbase > The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp > dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm > dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm > dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm