It was brought to my attention that the Find function does not work on all
entries in one of my Filemaker 8 databases.

Whether I use Find Mode or "Find Matching Records" command, I have a couple
entries (first name and last name fields) which cannot be found.

These were just typed into a new record. Any idea what causes this?

Thanks,
Steve @ ASU

If you are on FM8, then make sure you have upgraded to the latest rev,
which is 8.0v4 from FileMaker's website. v1-v3 had a variety of
indexing issues that would provide flaky finds. 8v4 fixes those issues.

Steve McGillivray wrote:
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Associate Member, FileMaker Solutions Alliance

"Steve McGillivray" <stagecraft (AT) cox (DOT) net> schreef in bericht
news:C2667593.696D%stagecraft (AT) cox (DOT) net...
Could you give an example of what it does, doesn't, should and shouldn't
find. In other words what did you expect and what did it actually return.


Keep well, Ursus

For example, you know that one person's record is giving FIND trouble. So
you go to that record and click in it's LAST NAME field, then right-click to
bring up the contextual menu and select "Find matching records" and you get
a message that it can't find anything matching your query.

Or you use the FIND function and put the first letter of the last name in
the LAST NAME field, click find, and it finds all the records that match
EXCEPT that one record you know should be there.

I should mention I'm using FM Pro Advanced.

Steve


On 5/9/07 12:32 AM, in article 464178f7$0$55088$dbd4b001 (AT) news (DOT) wanadoo.nl,
"Ursus" <ursus.kirk (AT) wanadoo (DOT) nl> wrote:

"Steve McGillivray" <stagecraft (AT) cox (DOT) net> schreef in bericht
news:C267EB67.69A7%stagecraft (AT) cox (DOT) net...
week. It is like searching doubles with the ! operator. You never know why
something does or doesn't come up. A far better way is to create a relation
on a self-join, TableA::Last_Name <-> TableA_sub::Last_name.
Create a count (TableA::Last_Name ; TableA_sub::Last_name> and find all the
counts with an amount greater then 1. The find matching records is not a
very reliable way to go.

And on the second part, this should work. But to makle sure, you could
create a test.
a calc field with Left ( TableA::Last_Name ; 1 )
now search on this field. If the record still is not there, there might be
something strange going on. I have experience 'ghost spaces' in the past. I
thought they where gone with fm7, but they just might be there. If you don't
find the record you expected, go there manualy. Highlight the field contents
en delete. Go out of the field with a tab (to commit the new value) and go
back in and retype the name. DON't use copy/paste, you will just paste any
error along.

Keep well, Ursus