Error when inserting records: another user has modified the record

I have a table, on some action i have to delele all the records and insert fresh records from another table means simple.

for this , first i am deleting records and after that i insert new records but at last i am getting error.

for delete i am doing this

DELETE============================

Bssi_rMilestoneDetailsInsert.RESET;
Bssi_rMilestoneDetailsInsert.SETFILTER(BssiBillingArcbScheduleNo, BssiBillingArcbScheduleNo);
Bssi_rMilestoneDetailsInsert.SETFILTER(BssiBillingLineNo,FORMAT(BssiBillingLineNo ));
IF Bssi_rMilestoneDetailsInsert.FINDSET THEN BEGIN
REPEAT
Bssi_rMilestoneDetailsInsert.GET(Bssi_rMilestoneDetailsInsert.BssiBillingArcbScheduleNo,Bssi_rMilestoneDetailsInsert.BssiBillingLineNo, Bssi_rMilestoneDetailsInsert."Line No.");
Bssi_rMilestoneDetailsInsert.DELETE(FALSE);
UNTIL Bssi_rMilestoneDetailsInsert.NEXT=0
END;

end DELETE==========================

for insert fresh records============================

ctr:=1;

REPEAT
Bssi_rMilestoneDetailsInsert.INIT;
Bssi_rMilestoneDetailsInsert."Line No.":=ctr;
Bssi_rMilestoneDetailsInsert.BssiBillingArcbScheduleNo:=Bssi_rScheduleLines.BssiArcbBillingScheduleNumber;
Bssi_rMilestoneDetailsInsert.BssiBillingLineNo:=Bssi_rScheduleLines."Line No.";

Bssi_rMilestoneDetailsInsert.INSERT;
ctr:=ctr+1;
UNTIL Bssi_rMilestoneItemLines.NEXT=0;

 

'==========================================

 after completion , i get error :

another user has modified the record for this table, after you reterived it from database. enter your chages again in the updated window,or start interupted again.

 

i have done lots of things to recitfiy to solve this.. but FAILS

 

PLEASE HELP !!!

 

(Subject changed by admin)

Related
Recommended