Ok this may be a stupid question...so please excuse me as I am just back to programming and new to 4GL all together..
I need to modify a program and can't wrap my brain around how to do it. The program splits percentage spreads based on codes for a person. Sometimes the same code may show up twice and the program inserts two entries for the table for that code with two different percentages instead of combining them. It reads one at a time figures the percentage and adds it to the table.
I can go back and find them - would like like this
Code Percentage UniqueID
123 15 12345
124 10 12346
123 75 12345
I need to go back and update row one to be 90 percent and delete row 3...
Can I treat the cursor as an array ex.. mycursor[1] or do I just navigate with FOREACH/ FETCH NEXT/PRIOR
Any thoughts would be great - Thanks
I need to modify a program and can't wrap my brain around how to do it. The program splits percentage spreads based on codes for a person. Sometimes the same code may show up twice and the program inserts two entries for the table for that code with two different percentages instead of combining them. It reads one at a time figures the percentage and adds it to the table.
I can go back and find them - would like like this
Code Percentage UniqueID
123 15 12345
124 10 12346
123 75 12345
I need to go back and update row one to be 90 percent and delete row 3...
Can I treat the cursor as an array ex.. mycursor[1] or do I just navigate with FOREACH/ FETCH NEXT/PRIOR
Any thoughts would be great - Thanks