Subject Re: SEARCHING VERY LARGE FILE From Mervyn Bick <invalid@invalid.invalid> Date Tue, 31 Aug 2021 15:50:40 +0200 Newsgroups dbase.getting-started 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. Mervyn.