3 Replies Latest reply on Jun 9, 2010 8:48 AM by philmodjunk

    Phantom Data?

    sk2_1

      Title

      Phantom Data?

      Post

      I am using Filemaker Pro 5. This is my first time with this program and I am experiencing some strange problems. I am using an already established database at the company I am interning for; however, the program does not always display a consistent number of records. For instance, one day when I open the database it says 12400 and the next day it says 12200. There seems to be no pattern and it jumps back and forth. I am concerned that the data is lost but it seems as thought it can be retreived from somewhere. Any help would be greatly appreciated.

        • 1. Re: Phantom Data?
          Ender

          Are you looking at the number of "Records" or the number "Found"?

          • 2. Re: Phantom Data?
            sk2_1

            I believe I am looking at the total number - the number displayed after clicking "Show All Records"

            • 3. Re: Phantom Data?
              philmodjunk

              Assuming you are in the same file each time you choose show all records, It is possible that your file is corrupted and that the file corruption is interfering with filemaker's ability to accurately count records. I had a filemaker 5.5 file that exhibited very similar behaviour. Sometimes a progress bar that displayed records remaining to be updated (such as in a replace field contents operation) would even display a negative number count. I could temporarily fix this issue by importing the records into a clone of the file. (To make a clone, choose save a copy as and specify the clone option). In my case, the problem would eventually return.

               

              I finally fixed the file by completely rebuilding it piece by piece after converting it to filemaker 10.