🚀 go-pugleaf

In article <bob.703022897@vincent1.iastate.edu> bob@iastate.edu (Robert P Kuehne) writes:
>Hi there.  I'm a novice Foxbase/Mac user.  I like it, but the program is
>more complext than I imagined.  Still...have a simple problem:  it seems
>that field entries are case sensitive, so that searching requires
>knowlege of case.  Is there a way to de-case-sensitize a search, so that
>whether I spell with upper or lower, the search will find the
>appropriate items.  If you know how to do this, please adivse.  I can't
>find the right switch.

Sorry, Bob, there is no 'switch' which you can set to turn case-sensitivity on 
or off.  No, you have to do everything manually.  You need to use the UPPER() 
or LOWER() functions to force the strings to either case and then search on 
them.  For example:

Your database has a field 'foo' containing the text 'Bar'.  The expression 

	LOCATE FOR foo = 'bar' 

will not find the record. Instead you could use this expression:

	LOCATE FOR UPPER(foo) = 'BAR'

or, if you have created a dialog box in an application, and storing the text 
to search on in the variable textToFind, use this:

	LOCATE FOR UPPER(FOO) = UPPER(textToFind)

That way the user won't have to remember to type stuff in upper/lower case.


>Thanks again.
>-- 
> -----------------------------------------------------------------------------
>|   |)  |		"Oh, it's _you_, Bob!"		     Robert P. Kuehne |
>|   |)()|)		  - That Commmercial		     bob@iastate.edu  |
> -----------------------------------------------------------------------------

Eric
-- 
===================================================================
               Eric Weidl    e-weidl@uchicago.edu
      University of Chicago -- Academic and Public Computing
===================================================================