AnsweredAssumed Answered

Stepping through a found set to duplicate records

Question asked by dsr1 on Jul 9, 2013
Latest reply on Jul 9, 2013 by dsr1

Title

Stepping through a found set to duplicate records

Post

     Hi All,

     I wish to duplicate selected records (within a found set), then change the field with the match criteria. My problem is that the found set grows each time I duplicate, even though the new record no longer matches the found set, so the next record is always the first created:

     Eg:

      

     Enter Find Mode

     Set Field [Table::Source_Job_SN; $SourceJobSN]

     Perform Find

     Set Variable [$Steps ; Value; Get(FoundCount)

        Exit Loop If [$Steps <1]

        Duplicate Record / Request

        Set Field [Table::Source_Job_SN; $NewJobSN]

        Commit Records / Request [No dialog]

        Go To Record / Request / Page [Next]

        Set Variable [$Steps ; Value; $Steps -1)

     End Loop

      

     I suspect I'm not using the found set correctly.

      

     PS I just noticed "Exit after Last" which looks like it will save manual counting.

      

     Peter

       

      

      

      

Outcomes