Home> Behaviors > Update form field data to MySql database table

Update form field data to MySql database table

Tagged: database, MySql, update

This topic contains 1 reply, has 0 voices, and was last updated by Anonymous 6 years, 8 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)

Author
Posts
November 13, 2012 at 1:24 am #1413

Anonymous
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 @ PerfectForms
Blocked
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.
Workflow software, Process software, Procedure software
Author
Posts

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.