Remove visibility of a row

gunseli

Hi,

I am using Datatable Editor. The following warning is given when I want to delete a row in the table.I'm getting this error because I get the data from Sql View.

I get the error on the following lines of code.

var table = $('#itemsDT').DataTable();
table.row( this ).delete(); or editor.remove(table.rows(idx), false).submit();

"View or function 'V_LineItemAndImpa' is not updatable because the modification affects multiple base tables."

Is there a way to remove the visibility of that row instead of deleting the row in a table?

allan

I would suggest against inserting, updating or deleting against a VIEW. You almost always want to use the VIEW to read data from a complex statement (i.e. clever joins or conditions that the Editor libraries don't support), but you want to actually manipulate the data on the host table.

This example shows that being done with Editor.

Regards,
Allan