NelsonFMP Posted January 31, 2011 Posted January 31, 2011 I just came across this issue and was using FileMaker 10 and 11. I have a simple database setup to record billing information and when I went to do a billing report, a simple find, one of my records for the given criteria was not coming up in the found set. I searched for a specific date range and a record within that range did not come up. I even tried searching for just that record and that fails. I've duplicated the record and the newly duplicated record act the same way. I used the recover option and recovered the database and although it didn't come up with any errors the record now shows properly during the search. Here's what I'm using: Database hosted on FileMaker Server 11 Accessing the file with FM 10 and 11 same results The field I'm searching is a standard date field. One the file was recovered it worked fine, but my concern is that I've been missing more billing records in the past and could miss some in the future and I would never know. Anyone experience this before?
Raybaudi Posted January 31, 2011 Posted January 31, 2011 I searched for a specific date range and a record within that range did not come up. Did you try to re-write the date inside that field ?
Keith LaMarre Posted January 31, 2011 Posted January 31, 2011 It seems likely that the index to that field may have been corrupted and would have to be recreated. I have had this issue in the past.
NBEA Intern Posted February 1, 2011 Posted February 1, 2011 It seems likely that the index to that field may have been corrupted and would have to be recreated. I have had this issue in the past. Keith, I think I have a similar issue with one of my databases. How would I go about seeing if the index is corrupted and potentially recreate it? - Dan
Vaughan Posted February 1, 2011 Posted February 1, 2011 Open the Define Fields dialog, open the field options and turn indexing off for that field. Close the dialog. Then open the dialog again and turn indexing on again. Field indexes do get corrupted, but not very often. I'd suspect bad data before a bad index. Also, make sure the field is a date field and not text.
Recommended Posts
This topic is 5045 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 accountSign in
Already have an account? Sign in here.
Sign In Now