Search results in error (1 record only)

[fundidor]

Hello Folks,

 

 

 

I have this very old database, 10 years old.

 

It is 120Mb big, and runs today on Filemaker 10 in an old G5 computer.

 

The DB contains invoices, customers, products, shipping companies, etc...

 

When searching the sentence "Rio de Janeiro" in invoices, it shows me the correct result, hundreds of invoices.

 

When searching "Rio de Janeiro" in Table "customers",  shows me one result only (wrong, there are hundreds of customers under Rio de Janeiro).

 

It seems that the search stops at the first record found and returns me only this record.

 

The problem repeat for all cells, like customer name, etc...

 

Can you please comment, What could be the problem, and how to debug this?

 

Thanks!

[doughemi]

First thing to try is to rebuild the index of the table.  This is most easily done by saving a compacted copy of the file (File->Save a Copy As...->compacted copy).

[LaRetta]

When searching "Rio de Janeiro" in Table "customers",  shows me one result only (wrong, there are hundreds of customers under Rio de Janeiro).

 

Hi Bernardo,

 

Another consideration ... are you searching on a layout which is based upon Customers?  Verify by, while in layout mode, selecting Layouts > Layout Setup and look at pop-up 'show records from'.

[fundidor]

Dear Doughemi and LaRetta,

 

Thanks for trying to rescue me.

 

I tried both tips, still shows me one record...

[LaRetta]

And you are sure you are in browse mode and not still in find mode showing one REQUEST?  Also there might have been a conversion error between versions over the years.  And you sure it isn't mis-spelled?  What do you get if you just search for Rio?

 

Otherwise we will probably need to see your file. 

[fundidor]

If I export all the records from the customers' tables, into another FM file, I have 665 customers.

 

Then I enter search in the new created file (DB) and it works, I have 134 customers that are in Rio de Janeiro.

 

My best guess is that somewhere in time the DB was closed (power failure) and recovery routines crippled the DB.

 

I am an Objective C programmer, I have never been so experienced in FM.

I tried also exporting/importing the records, and the problem persists.

[bruceR]

Is the original field actually defined as a text field?

 

If the field is defined, for instance, as a number or date field, your results are exactly what we would expect.

 

The field contents can be text; and will behave just as you describe when exported.

 

What happens when you enter find mode, click into the field, and choose menu "Insert from Index"

 

What does the index show you?

[fundidor]

Yes, it is an indexed text field...

 

Please see attached screenshot:

 

 

[bruceR]

And if you go ahead and pick Rio and then Find it doesn't work? If you pick other values - they work?

[LaRetta]

Also, is the field set as Unicode?  Look in field Options > Storage > Default language.  Were values copy/pasted in?  Could there be lower ASCII or odd characters or accents?  What if you export the data as csv then import it back in, over-writing the value, then searching?  You need to pin down whether it's the data or the file, I think.

[fundidor]

And if you go ahead and pick Rio and then Find it doesn't work? If you pick other values - they work?

Yes, find only shows 1 result, or one customer from Rio de Janeiro, but there are 134 customers from Rio de janeiro.

Also, is the field set as Unicode?  Look in field Options > Storage > Default language.  Were values copy/pasted in?  Could there be lower ASCII or odd characters or accents?  What if you export the data as csv then import it back in, over-writing the value, then searching?  You need to pin down whether it's the data or the file, I think.

The problem is with the table, not the database, I export the records, and import them back, and the problem persists.

 

If I just open the exported records from the table as a Filemaker Pro DB, search shows me the correct result.

 

As I said, the search problem occurs also in other cells, it seems that the search routine stops searching when it hits the first matching record, always displaying just one record.

 

In portuguese language we use special characters like ç, é, ã, etc...

 

I don't know why they would change anything...