1 Reply Latest reply on Aug 4, 2010 2:14 PM by philmodjunk

    Question Marks???

    trizko

      Title

      Question Marks???

      Post

      Some of the records, in my companies FM database, have a "?" character in all fields.

      If I perform a find with a "?" character, it does not return any results.

      What does this mean?

        • 1. Re: Question Marks???
          philmodjunk

          This is a known issue with filemaker: Phantom Record, damaged file message, Recover can't detect a problem

          The record with the ??? doesn't actually exist but part of your filemaker file thinks it does. You can't delete them either. You can fix the issue by re-indexing the affected field. Since it can be difficult to figure out which field to re-index, the simplest approach is to use the Save As.. action with the clone option to save an empty copy of your file and then import all your data from all your tables into this clone. The import process rebuilds the indexes of all your fields and you shouldn't see any more fields with question marks.

          This is one of many bugs that can be found in the Known Bug List here in the forum.

          This list can also be downloaded for free as a filemaker database for easier searching from: 

          http://www.4shared.com/file/8orL8apk/FMP_Bugs.html