I've got an issue that I'm having trouble working thru and I'm sure that I'm probably over thinking all of this just need someone to break me out of my brain lock.
I have 54 records in a MySQL table that I will need to run calculations on one at a time and then loop thru the records until done. ( SELECT COUNT(*) AS TotalRecords FROM table1 )
Read 1st Record in table1.
Run (6) different calculations on specific fields and get (6) separate results. (easily done with SQL query)
Write the (6) results from 1st Record to table2 to specific fields using DataAssist.
Run a (3) new calculations on the results stored in table2 for 1st Record to obtain (3) new results. (easily done with SQL query)
Write the (3) results from Step 4 to table2 specific fields using DataAssist.
Loop back to Step 1 and move to the next record not processed. This should run through all the records until complete.
My issue is the coding for Step 6. What is the best way to go about accomplishing this task? I can easily step through steps 1-5 for the 1st record.
Many thanks in advance!