Jump to content
Sign in to follow this  
Will Loving

Quickfind Case Sensitive?

Recommended Posts

I'm setting up a scripted Quickfind for a project and in the course of testing it find that it is returning case-sensitive results, so for example if I enter "human" in the QF field, it is only returning results that match "human", ignoring "Human". I've used QuickFind before and have never seen this behavior. I know how to create a workaround for it: creating a calc field for fields I'm performing the Find on with the Lower( ) function and doing the same using Lower( Get(QuickFindText) ) for the script step, but I can't figure out why it's only doing case sensitive Quick Finds in the first place.

The specific variables are that: 1) I'm using FMPA 15 ; 2) It's a simply scripted QF, nothing out of the ordinary; 3) The fields being searched are all Indexed text fields; 4) the fields ARE locating in a separate file.  In checking around I did find that QuickFinds using External SQL data sources ARE case sensitive by default, but that doesn't address the issue where the records are in another local file but it's all FileMaker...

Share this post

Link to post
Share on other sites

1.  Is this behavior limited to Quick Find or does normal find in the same fields behave the same way?

2. What do you have selected as the default indexing language for the fields in question?

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.