Jump to content

Find results in more records than contained in fil


This topic is 7463 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi

I've been using FMPro for many years but have never come across this.

I have a file converted from 4 to version6.

It contains518 records all of which have the same year. One of the fields contains the year.If I search based on the year i get 1151 records and they are all displayed in a list view!!

If I search on any other field i get what i expect.

Any thoughts anyone?

Link to comment
Share on other sites

That wasn't a typo was it? Your list view is actually displaying more records than you should have in the file? If so, it looks like there were some deleted records that were never physically removed, and the index has become corrupted. I would try saving the old file as a compressed file before converting it to version 6. If that doesn't work, then try to recover the file before converting it.

Link to comment
Share on other sites

I don't ever recall having a find produce more records than are supposed to exist, but I've definitely had finds produce obviously wrong results. Whenever that happens (assuming I didn't make some other mistake), it's a sure sign the index is corrupt.

Platform: / Version:

FileMaker Version:

Link to comment
Share on other sites

This topic is 7463 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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