|Like there are four Rows
S.No Total Received Balance Delete
1 1000 100 900 Delete
2 1000 200 700 Delete
3 1000 300 400 Delete
4 1000 400 0 Delete
if i delete the first row then the effect will take place on the balance column in the 2nd, 3rd , 4th column.
I want to use the sql queries in (Stored Procedure)database and not in the form
Now i am telling u what i thought to do it
first select statement , to fetch all the records, then one by one i will subtract the received from the total and ba;lance will be updated.
This is what i want to do.
Yahoo Messenger Id = soniagupta1