2 Replies Latest reply on May 2, 2014 4:37 PM by philmodjunk

    Data in repeating field is getting corrupted.

    PaulArnold

      Summary

      Data in repeating field is getting corrupted.

      Product

      FileMaker Pro

      Version

      12

      Operating system version

      Mac OS 10.9.2

      Description of the issue

      I have 750+ records in a Invoicing file.
      I have one field called "description" that repeats 9 times on each record. The first instance of that repetition is suppose to be different on each record but it just started appearing IDENTICAL on all my records. I had this problem a few years back and I upgraded to the latest FileMaker to try to fix it. Worked great for a year and a half and now is corrupted again.

      Steps to reproduce the problem

      Opened an earlier back-up of the file

        • 1. Re: Data in repeating field is getting corrupted.
          TSGal

               Paul Arnold:

               Thank you for your post.

               A repeating field is a single field that contains many values.  Each repetition is separated by a control character (ASCII 29).  If the first instance is displaying the same information for each record, but the other repetitions are not affected, then there may be some corruption in the field.

               The next time this occurs, try closing the file, quit and relaunch FileMaker Pro, and open the file.  If the correct data appears, then this may be a memory issue.  If the incorrect data still appears, then close the file, and run a Recover.  When the recover finishes, open the recovered file.  This may or may not show the correct data.  If it doesn't show the correct data, then import the repeating data from the last good backup file, and use the option to update the existing records.

               Let me know if you continue to run into difficulty.

               TSGal
               FileMaker, Inc.

          • 2. Re: Data in repeating field is getting corrupted.
            philmodjunk

                 In FileMaker, it's relatively easy to use Import Records to move data from a repeating field or group of repeating fields into a set of related tables with one related record for each value in a repetition.

                 This may be a good time to consider making that design change for this data.