Finance | Project Operations, Human Resources, ...

Null values leftover after deleting last record shown on grid

(2) Share

Report

Posted on by DHRPTony

Currently, when the last record of the grid is deleted, it leaves behind the null values of its respective fields. This does cause some fields to appear having something in them, even when there should be no records showing. I have tried setting the property "Insert if Empty" to No in the data source but it still shows up.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (5)

Answers (0)

DHRPTony 34 on at

Like (0)

Report

Null values leftover after deleting last record shown on grid

Hi @Mohamed Amine Mahmoudi,

when the user clicks on the button, it looks at the selection and inserts data into another table based on. The data that is in the grid shown should than be deleted leaving a grid to show nothing. However as shown in the screenshot provided left behind is a record of everything null value. I have checked the sql afterwards as well, and no record exist that have all null values.

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,292 Super User 2025 Season 2 on at

Like (0)

Report

Null values leftover after deleting last record shown on grid

Hi @DHRPTony,

Are you sure you don't have any code to force the insertion?

If not, can you share more details with us ?

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
DHRPTony 34 on at

Like (0)

Report

Null values leftover after deleting last record shown on grid

Hi @Komi Siabi and @Mohamed Amine Mahmoudi,

both insert if empty and insert at end are set to no, and the result is still the same.

Regards,

Tony.

Was this reply helpful? Yes No
Komi Siabi 13,019 Most Valuable Professional on at

Like (0)

Report

Null values leftover after deleting last record shown on grid

Hi,

Insert if Empty works when you load the form, hence you should also take into consideration the Insert At End

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,292 Super User 2025 Season 2 on at

Like (0)

Report

Null values leftover after deleting last record shown on grid

Hi @DHRPTony,

You need to set also the property "Insert At End" to No

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No