Immediate insertion through codeunit

sabzam

Dear All,

I have got 1000 records whcih are to be inserted one after the other. But I would like that even if there is an error in record 400 the 399 records (i.e. the records before the error) are inserted.

Is this possible?

HalMdy

I assume you have some code like :

REPEAT
           Rec.Field1 := ...
           Rec.Field2 := ...
           Rec.INSERT(TRUE);
         UNTIL ...

In place of making a unconditionnal Insert, make something like :

IF NOT Rec.INSERT(TRUE) THEN ... (put info in a lock)

Hope that help.

kine

You will need to call commit after each insert to end the transaction and insert the next record in another transaction.

sendoh

u can commit every 100 record

IF ((iCtr MOD 100) = 0) THEN
COMMIT;

sabzam

Hi It has worked fine. Thanks for your reply