Highlighted

Multi-Record DB Inserts/Updates

Ryan_M__Jacobs

08-10-2008

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!

Replies

Highlighted

Jasmin_Charbonn

09-10-2008

That's the only way other than using the Script service or writing your own custom component and write code to do the looping.



Jasmin