1 Reply Latest reply on Oct 9, 2008 4:11 AM by Jasmin Charbonneau

    Multi-Record DB Inserts/Updates

    Ryan M. Jacobs
      I have a situation where I will receive a form that contains a repeating node of data for which I will need to do a database update or insert for each repeated node.

      Is there an efficient mechanism to iterate over these nodes and call the Execute SQL Statement as many times as there happen to be nodes? I have seen examples of looping constructs where you must set counters as process variables and then have a setValue process update that each time and combine it with a decision point to check if the counter matches the nodecount.

      I am hopeful there might be a more efficient way to do this that I am overlooking.

      Thanks in advance!