Skip to Content
Former Member
Aug 16, 2009 at 08:25 PM

"cannot insert null into column.." ErrorWhen I delete Last row in a Matrix


I have created a form where I show the document's data in the header form and a matrix for showing document lines data.

I can insert records and update records from this form for header as well as matrix tables.

My problem is in deleting records from the matrix. For deleting the row from the matrix, on "Delete" item pressed event I call oMatrix.DeleteRow function for the selected row. This function deletes the row from the matrix. It also deletes the record from the document lines table if the number of rows are more than one. But in case of only one row in the matrix, on deleting the row, I get an exception saying "Cannot Insert null in the DocEntry field".

Edited by: vishypat on Aug 16, 2009 10:26 PM