Start a new topic

Sql Server : Data Editor table with computed column

[This topic is migrated from our old forums. The original author name has been removed]

Currently, the Data Editor doesn't work if you try to insert rows in tables containing computed columns (in SQL Server), because DbVis tries to insert values also in computed column. Best regards Michele

[This reply is migrated from our old forums.]

Re: Sql Server : Data Editor table with computed column
Michele, If you don't want to pass certain cells or columns to the database when save in the data editor, just select the cells and click Undo or right-click and select "Undo". The opposite to force cells to be part of the final update SQL (even if not edited). Right-click, choose Edit Table Data->Mark Selected Cells as Edited. I hope this helps. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: Sql Server : Data Editor table with computed column
Hello Roger, Thanks for the answer that solved my problem. Michele