I've rolled back my all entries when error occurred in loop al?

(0) Share

Report

Posted on by n_dev777

Hi,

I've rolled back all my entries when an error occurred. I 've a button and a code which save the entries in loop but I don't want to rolled back the already saved entries. Please anyone can help.

Categories:

Business Central

All responses (5)

Answers (1)

n_dev777 20 on at

Like (0)

Report

RE: I've rolled back my all entries when error occurred in loop al?

please can you share any example snippet or suggestion how to handle?
Suggested answer

Mohana Yadav 59,139 Super User 2024 Season 2 on at

Like (0)

Report

RE: I've rolled back my all entries when error occurred in loop al?

Yes, if any error occurs then the entries written before commit will not be rolled back.
n_dev777 20 on at

Like (0)

Report

RE: I've rolled back my all entries when error occurred in loop al?

but I want if any error is occurred then it will not be rolled back entries which are saved.
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: I've rolled back my all entries when error occurred in loop al?

Hi,

Yes as per Mohana, you can use COMMIT function before your statement "until table.next = 0;"

Thanks.
Verified answer

Mohana Yadav 59,139 Super User 2024 Season 2 on at

Like (0)

Report

RE: I've rolled back my all entries when error occurred in loop al?

You can use Commit function.

learn.microsoft.com/.../database-commit-method