This topic contains 1 reply, has 0 voices, and was last updated by Anonymous 6 years, 2 months ago.
- November 13, 2012 at 1:24 am #1413
I created a form with a connection update action. On the same form I’ve attempted to create a loop behavior that 1. sets the table at the first record, 2. checks the current row field to be returned to the MySql database table for the correct field content, 3. submits the record, 4. moves to the next record and repeats the process.
Still, the connection only updates the first record in the database or, (if I make a change in the behavior) all the records with the same data as the first record. Can anyone offer any direction on how to get the form to update the database table with the field data from each record?November 13, 2012 at 4:37 pm #6318
Dennis @ PerfectFormsBlocked
To troubleshoot I would first test your table looping behavior to make sure that it is going to each row and doing its check. Do this by using a Show Message object (value of field in row) before moving to next row.
If your looping behavior is working correctly (I think that it probably is not)and your SQL table is still not updating, you may have to build a timed pause in the behavior as it moves from row to row to slow it down and give your SQL server a chance to catch up.
You must be logged in to reply to this topic.