Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Multi-Record DB Inserts/Updates

Avatar

Avatar
Validate 1
Level 2
Ryan_M__Jacobs
Level 2

Likes

0 likes

Total Posts

22 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 2
Ryan_M__Jacobs
Level 2

Likes

0 likes

Total Posts

22 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
Ryan_M__Jacobs
Level 2

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

Avatar

Avatar
Coach
Level 10
Jasmin_Charbonn
Level 10

Likes

149 likes

Total Posts

2,154 posts

Correct Reply

97 solutions
Top badges earned
Coach
Give Back 1000
Give back 900
Give Back 800
Give back 600
View profile

Avatar
Coach
Level 10
Jasmin_Charbonn
Level 10

Likes

149 likes

Total Posts

2,154 posts

Correct Reply

97 solutions
Top badges earned
Coach
Give Back 1000
Give back 900
Give Back 800
Give back 600
View profile
Jasmin_Charbonn
Level 10

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