3 Replies Latest reply on Apr 10, 2014 5:36 PM by StanMillar

    Xpost: Since the update portal refresh not working

    StanMillar

      Summary

      Xpost: Since the update portal refresh not working

      Product

      FileMaker Pro

      Version

      Advanced 13.0 v2 Updater: FMP13.0.2.22

      Operating system version

      OSX 10.9.2

      Description of the issue

      I have a menuing system that operates as follows:

      Click on a menu item in a portal which runs a script:

      Go to a developer layout attached to the Menu TO
      determine if the menu item clicked has sub-menu items
      If it has, change the arrow displayed beside the menu item clicked (gives the same effect as clicking on a folder in the Finder)
      load up the sub menu IDs into fields so that they display in the menu portal on the original (home) layout and some other housekeeping
      return to the home layout where the arrow has changed to the new graphic (pointing down) and the top level menus and the sub menus from the one clicked are displayed. Well - no.

      All this has worked perfectly for years.

      Since the upgrade, the script runs, the arrows change BUT the sub menus refuse to display. On the developer layout, I can see that things have changed to add the sub menu IDs into the correct fields for display.

      If I manually navigate to the developer layout from the home layout and then immediately return to the home layout - there they are - displayed in all their glory!

      I have tried:
      add refresh window after returning to the home layout. No change.
      add commit record both before and after returning to the home layout. No change.
      add steps to navigate to the home layout, back to the developer layout and back to the home layout . No change.

      If I open the file in FM12 Advanced, everything works.

      Seems like something has changed since the update. I hate to say the "b"(ug) word but nothing else has changed.

      The menu portal on the home layout shows the menu records via a multi-predicate relationship. In all cases, the top level menus continue to display. This is the correct behaviour as their IDs are listed in the foreign key field.

      The opposite effect occurs if the user (me) clicks to "close" a menu. The arrow changes, as it should, but the sub-menus continue to display. I can verify that their IDs are removed from the foreign key field.

      Refresh Object script step after a commit with flush cache.

      Added a new portal to the home layout showing the menu name field and the fk field then manually copied the IDs into the fk field in this portal. This worked. The menus showed up in the menu portal.

      New wrinkle.

      The sub menus (the correct ones for that top level menu) show up in the menu portal only _after_ the top level menu is "closed" and their IDs are _removed_ from the fk field by the script!! At this stage in the process, they are _not_ related.

      There is something very strange going on here. To say the least.

      I added a fresh instance of the menu portal to the home layout. The result is the same so it is not a problem with the original portal.

      Expected result

      portal records update

      Actual result

      portal records do not update

      Exact text of any error message(s) that appear

      nil

      Workaround

      SOLVED:

      If I open the developer layout in a separate, hidden, window, all the problems go away without any pauses in the script.

      How this differs in refreshing the window from using the script step, I don't know, but at least it works.

        • 1. Re: Xpost: Since the update portal refresh not working
          StanMillar

               Update:

                

               Workaround

                

               If I pause the script for .55 (yes .55) seconds after flushing the cache and before returning to9 the home layout, it works as expected. Any delay less than .55 seconds does not work.

                

               Stan

          • 2. Re: Xpost: Since the update portal refresh not working
            TSGal

                 Stan Millar:

                 Thank you for your posts.

                 Did this work correctly in FileMaker Pro 13.0v1?  Or, did you update from FileMaker Pro 12 to FileMaker Pro 13.0v2?

                 If possible, I would like to see a copy/clone of your file so I can test it and report the differences to Testing and Development.  Please check your Inbox at the top of this page for instructions where to send the file.

                 TSGal
                 FileMaker, Inc.

            • 3. Re: Xpost: Since the update portal refresh not working
              StanMillar

              Hi TSGal

              Thanks fort your interest.

              The routine worked correctly in FileMaker Pro 13.0v1 and stopped working
              after the upgrade to FileMaker Pro 13.0v2.

              I solved the problem by opening a new window based on the developer layout
              off screen (-10000).

              I use the separation model, so I will clone the data files and send three
              files to you this morning.