Re: Applylocate

Rob Rickard wrote:
> Hi All
> l'm trying to make sure the search for a name is the same as in the
database ie if somebody types in Smith and SMITH is in the database then
applylocate finds it.Is there an easy way like upper() or should l readjust my
thinking to accomodate a better way.
> On a side note l would like to thank all the people that respond to these
forums and make DBI the great program that it is.l get a lot out of reading what
other programers are trying to do and what they achieve.

Use locateOptions -- this allows you to ignore case ... check it out in 
online help.

Ken

-- 
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase/dBASEBooks.htm

Hi All
l'm trying to make sure the search for a name is the same as in the database ie
if somebody types in Smith and SMITH is in the database then applylocate finds
it.Is there an easy way like upper() or should l readjust my thinking to
accomodate a better way.
On a side note l would like to thank all the people that respond to these forums
and make DBI the great program that it is.l get a lot out of reading what other
programers are trying to do and what they achieve.

Ken Mayer [dBVIPS] Wrote:

> Rob Rickard wrote:
> > Hi All
> > l'm trying to make sure the search for a name is the same as in the
database ie if somebody types in Smith and SMITH is in the database then
applylocate finds it.Is there an easy way like upper() or should l readjust my
thinking to accomodate a better way.
> > On a side note l would like to thank all the people that respond to
these forums and make DBI the great program that it is.l get a lot out of
reading what other programers are trying to do and what they achieve.
> 
> Use locateOptions -- this allows you to ignore case ... check it out in 
> online help.
> 
> Ken
> 
> -- 
> /(Opinions expressed are purely my own, not those of dataBased
> Intelligence, Inc.)/
> 
> *Ken Mayer* [dBVIPS]
> /Golden Stag Productions/
> dBASE at goldenstag dot net
> http://www.goldenstag.net/GSP
> http://www.goldenstag.net/dbase/dBASEBooks.htm
> http://www.goldenstag.net/dbase


Thanks Ken
    onkey()  is looking like a good option as well (using an index)

In article <orTO0rGjIHA.1096@news-server>, rob@calculation.com.au 
says...
>  
> Thanks Ken
>     onkey()  is looking like a good option as well (using an index)
> 

Why reinvent the wheel?  Check out the seeker.cc control.

-- 
Marilyn Price