Search is finding all records not just the specific record

[clhein]

When I use Find to search for one record by name it is finding all the records in the database rather than the specific record I am looking for. This is on a server edition.

[Fitch]

Is this Find in a script?

[clhein]

No, it isn't a script. Those finds are actually working fine. When we go to use the Find button on the left, though, it is summarizing all the fields and doesn't seem to be finding on what we request.

[John Mark Osborne]

Can you give us an example of your find criteria and the records it is finding? Also, include what it should find. It may be you just need to add some optional symbols so FileMaker doesn't search each word. For example, searching for "Mar" in the first name field will locate the following:

Marc

Mark

Marcus

John Mark

That's because FileMaker searches the beginning of each word when searching a text field. There are a variety of optional symbols you can use to focus your search. For example, entering ==John Mark will only locate first names containing the complete text following the double equal signs.

[clhein]

It was a server issue-we needed to download an update. Thanks for the help though!

[clhein]

My find script isn't including all the records. I have it set up to perform a find when one field equals Weekly and another equals Yes. The same set up works every other time, but here it keeps leaving 5 or 6 records that qualify out. I've already checked the data and everything is there. Any ideas?

[mr_vodka]

Double check the filed types and also your find script.

[clhein]

Yeah-done all that. I am dealing with strictly text fields. The script begins with Perform Find and instructs to find records when the first field is Weekly AND the second field is Yes. After that it the script just sorts records and returns to browse mode.

[mr_vodka]

Does it happen with a manual find?

[clhein]

No that is the weird part. Manually, it finds the records perfectly.

[Lee Smith]

[color:red]Attention to members helping with this question. I merged two of clhein's posts because he/she had received several responses, so that is why many of you have posted the same advice.

I have also sent a private message to clhein about not double and tripple posting.

Lee

p.s.

The one I deleted had my response, and I noticed that it was in the Container Topic. Is one of the criteria based on finding something in a Container field?

[clhein]

No container field here-it actually should be pretty straight forward. Just a script combining the two criteria for a find. We have the same script set up for 4 or 5 different situations in the database and it works perfectly. Only a problem here for some reason. This database is on a server if that makes any difference?

Apologies for the double post by the way. I caught that I had put it in the wrong section and got pulled on another project before I could take it down.

[Lee Smith]

Well, there are a couple of clues here.

One, if the other finds are script exactly like the one that fails, what is the difference in the data, criteria, etc.?

How are the files being accessed? Some Script Steps may not be compatible.

Peer to peer, server, web,?

Post a copy of your script, all of it, not just the find part if there are additional steps.

Lee

[clhein]

The data is being accessed via server. No difference in the data besides the first find criteria in the working scripts is technically a number (the field is still set up as text)and now it is the word weekly. The data is feeding from one database into the one with the malfunctioning script but I've checked the records and all the data is correct.

Rookie question here-how do I post my script online?

[Lee Smith]

Numbers in a text do not work the same as numbers in number fields.

Do a sort on your field and you should see what I mean.

Lee