8 Replies Latest reply on Feb 22, 2012 9:37 AM by disabled_JackRodgers

    FM Go “GetNthRecoder” Bug

    xinge

      Title

      FM Go “GetNthRecoder” Bug

      Post

      hi,i used FM Go in iPad.   A  field is calculated used "GetNthRecoder" , if the record total of more than 29, the results can not be displayed。it is bug?

      29%E5%8F%B7%E8%AE%B0%E5%BD%95.PNG

        • 1. Re: FM Go “GetNthRecoder” Bug
          TSGal

          xinge zhang:

          Thank you for your post.

          I am unable to replicate he problem on my iPad.  This is what I have done.

          1. I created a database file, Test.fp7, with one table and one field:

          Field1 (Text)

          2. I imported a text file of 500 names into Field1

          3. I changed the contents of Field1 in record 50 to "TSGal"

          4. I created a Calculation field Calc1, resulting in text with the formula:

          GetNthRecord ( Field1 ; 40 )

          5. I displayed the Layout in List view.

          6. All records show "TSGal" in the field Calc1

          7. I turned on Network Sharing for All users.

          8. In FileMaker Go, I opened Test.fp7 as a guest, turned on List View, and went to record 200+.  All records continue to display with "TSGal" appearing in the field Calc1.

          Please let me know what I am doing differently than you, and I'll try to replicate the problem here.

          TSGal
          FileMaker, Inc.

          • 2. Re: FM Go “GetNthRecoder” Bug
            xinge

            Hi,TSGal

            thank you answer,I have a test file, to reproduce the problem, I can send you, give me your email please

            • 3. Re: FM Go “GetNthRecoder” Bug
              TSGal

              xinge zhang:

              Please check your Inbox at the top of this page for instructions where to send the file.

              TSGal
              FileMaker, Inc.

              • 4. Re: FM Go “GetNthRecoder” Bug
                philmodjunk

                Some uses of GetNthRecord result in another layer of computation for stacking up for each each additional record in the found set or portal--basically a form of recursion. Since this is on an iPad or iPhone, the smaller memory capacity of this device could hit such a limitation much sooner than in FileMaker Pro on a regular computer. That may explain the issue here.

                If this is just to compute a total of all the records or a running total, try using a summary field instead of GetNthRecord.

                • 5. Re: FM Go “GetNthRecoder” Bug
                  TSGal

                  xinge zhang:

                  I received your file.  Thank you.

                  I am able to replicate the problem in FileMaker Go.  This occurs with any file that uses a running balance, when using the unstored calculation "GetNthRecord - 1" to capture the balance from the previous record.  After the 29th record, the balance field returns a question mark.

                  I have forwarded your post along with my findings to our Development and Software Quality Assurance (Testing) departments for review and confirmation.  When any information becomes available, I will let you know.

                  TSGal
                  FileMaker, Inc.

                  • 6. Re: FM Go “GetNthRecoder” Bug
                    TSGal

                    xinge zhang:

                    I apologize for the late reply.

                    Our Development and Testing departments confirmed this is an issue with the limited memory on an iOS device (at this time).

                    One possible workaround is to use a script to obtain the same result.

                    TSGal
                    FileMaker, Inc.

                    • 7. Re: FM Go “GetNthRecoder” Bug

                      Go to Previous Record snip followed by Go To Next Record might solve the problem.

                      • 8. Re: FM Go “GetNthRecoder” Bug

                        Since a summary is involved try

                        Set current record id into variable $_id

                        constrain ($_id)

                        get totals

                        extend ($_id)

                        do whatever