Fields are full of ??????
In one of my databases I have several records that have "?" in all fields. Other than that, it seems to operate normally. Any help?
This is a known bug. The fix is to either re-index the right field(s) or to import all your data into a clone of the same file (which rebuilds all the indexes.)
For more info on the subject:
Thanks. This occurred with a damaged file in FM11 with a Mac, after a recovery.
While recovery is a useful tool, best practice is to never use a recovered file. If recovery is needed to repair a file, it is much safer to replace it with an undamaged backup copy if you have one.
My experience is that this represents a previously deleted record. it is a problem with the record index and not with any of the field indexes. Reindexing fields will likely not help. To resolve the issue, you can create a clone of your database and then import all data into that clone.
Re-indexing has worked for me (There was no record deletion taking place when I encountered this issue in my DB) and I also recommended the import to clone if re-indexing failed to fix the problem.
??'s are defiantly a sign of corruption in an index. I have fixed many files by reindexing all the indexed fields in a file. (I have had it fail if I did not open the file locally first) Sometimes this is caused by deleted records not being gone but are any number of other things that can cause this including a corrupt data structure, filemaker 8.0 (unpatched) doing finds, illegal characters, ....
A recovered file shouldn't be used (It may corrupt parts of the file in order for you being able to open it and get your data out).
Having said that, I have used recovered files successfully for many years but have also seen them fail miserably.
So, import your info into a cloned copy of your org file if possible(this will also rebuild the indexes)
One additional thing. With versions of FMP 10 and above, one can now use the recover functionality to just rebuild all the indexes with using the advanced options. Do not drop any blocks and check the option for rebuilding the indexes.
Retrieving data ...