Hi All,
i've below records on my cursor
rcno debit credit remainder
==== ===== ====== =========
1 0 100 0
2 0 200 0
3 100 0 0
4 200 0 0
i'want to calculate and replace for remainder field for the first record
0 - 100 = -100
then
2nd and others shoulbe
* first remainder value + debit - credit
2nd -100 + 0 - 200 = -300 )
3rd -300 + 100 - 0 = -200
4th -200 + 200 - 0 = 0
how can i do this in a scan..endscan or for next loop ?
TIA