2 Replies Latest reply on May 3, 2011 11:10 AM by MatthewMackay

    Temperamental Script

    MatthewMackay

      Title

      Temperamental Script

      Post

      Afternoon all,

      I've got a script that I thought was working fine but it has recently been showing some temperamental behaviour. The script is used to copy a parent record with all it's child records.

      If someone can see any issues with the script, please let me know. Sometimes it works fine, sometimes it copies just the parent record, no idea what's happening.

      Screen_shot_2011-05-03_at_17.25.51.png

        • 1. Re: Temperamental Script
          philmodjunk

          We came across what looks like the same issue with another person a short while back.

          How many records are in your found set of parent records at the moment this script is performed?

          We discovered that the above script, which I've recommended to a number of users, will not work correctly unless the parent record being duplicated is either the last record in the found set or the only record. Embarassed

          We fixed the problem by making a few small changes to the script:

          After Freeze Window, add this step:

          Set Variable [$RecordNumber ; get ( RecordNumber ) ]

          Then change the go to previous record step in line 6 above to:

          Go To Record/Request/Previous [$RecordNumber ; no dialog ]

          Finally change the go to next record near the end to:

          Go To Record/Request/Previous [Last]

           

          This assumes that the records in both layouts are Unsorted.

          • 2. Re: Temperamental Script
            MatthewMackay

            Legend!!!

            You just ended days of turmoil Laughing

            Cheers