Jump to content
Sign in to follow this  
Christer

Search error in combination with letter "M" ?

Recommended Posts

I recive wrong search result when searching textfield as described below.

Register contains following records in standard textfield:

MSG 85/731 MAXIMO M

MSG 85/731 MAXIMO M TRUCK

MSG 85/731 MAXIMO L

MSG 85/731 MAXIMO K

MSG 85/731 MAXIMO K TRUCK

MSG 85/731 MAXIMO J

MSG 85/731 MAXIMO L TRUCK

MSG 85/731 MAXIMO J TRUCK

When seraching for MSG 85/731 MAXIMO M the result shows all 8 records !!!!!

When searching for MSG 85/731 MAXIMO L or MSG 85/731 MAXIMO J or MSG 85/731 MAXIMO K, I get the correct result (2 found records).

When searching for MSG 85/731 MAXIMO TRUCK I get 4 found records. (All that contains truck).

This is made i a Filemaker 4.1sv1 (swedish). The register contains no other fields and I don't use any optinals in the search.

Any ideas ?

[ September 12, 2001: Message edited by: Christer ]

[ September 12, 2001: Message edited by: Christer ]

Share this post


Link to post
Share on other sites

This is a basically due to the way that Filemaker treats searches when only search ciiteria is entered. In fact most search engines will return the same result set.

By default all Finds are setup as "OR" or "ANY" criteria. Meaning that Filemaker will return all the records that match on any of your words.

There are many ways to get Filemaker to be more specific in its finds. Using the == operator will cause Filemaker to look for an EXACT match, as will enclosing your criteria in "", as this causes Filemaker to treat everything within as a single word.

There are lots of other operators as well, look in the Help for an explanation of what each one does.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    Christoph 
×
×
  • Create New...

Important Information

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