kishor choure

kishor choure

  • NA
  • 87
  • 46.2k

What can I do at this situation?

Aug 18 2012 11:00 AM
I create feetbl having following fields:

f_id bigint
f_receipt char
f_totalfee bigint
f_paidfee bigint
f_remainingfee bigint
f_paid_date datetime
f_due_date datetime

when I insert records in feetbl by following values

1 rec1 40000  20000  20000  20/07/2012   30/09/2012

Here I added one record but when candidate approach to me for giving all remaining fees with new receipt number then How can I update this remaining fees by new receipt number??

 Give me solution of this by considering multiple records.

Thanks in advance.




Answers (7)